APPS.PAY_SE_SALARY_STRUCTURE_STATS dependencies on PAY_PAYROLL_ACTIONS

Line 54: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;

50: , p_segment_number IN NUMBER DEFAULT NULL
51: )
52: RETURN VARCHAR2
53: IS
54: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
55: l_start_pos NUMBER;
56: l_delimiter VARCHAR2 (1) := ' ';
57: l_proc VARCHAR2 (240) := g_package || ' get parameter ';
58: BEGIN

Line 145: FROM pay_payroll_actions

141: , 'REPORT_YEAR'
142: )
143: ) L_REPORT_YEAR
144: , effective_date, business_group_id bg_id
145: FROM pay_payroll_actions
146: WHERE payroll_action_id = p_payroll_action_id;
147:
148: lr_parameter_info csr_parameter_info%ROWTYPE;
149: l_proc VARCHAR2 (240)

Line 360: ,pay_payroll_actions ppa

356:
357: p_sql :=
358: 'SELECT DISTINCT person_id
359: FROM per_people_f ppf
360: ,pay_payroll_actions ppa
361: WHERE ppa.payroll_action_id = :payroll_action_id
362: AND ppa.business_group_id = ppf.business_group_id
363: ORDER BY ppf.person_id';
364: g_payroll_action_id := p_payroll_action_id;

Line 2104: pay_payroll_actions ppa

2100: IS
2101: SELECT pai.action_information6 Report_Year
2102: FROM
2103: pay_action_information pai,
2104: pay_payroll_actions ppa
2105: WHERE
2106: ppa.payroll_action_id=csr_v_payroll_action_id--175110 --csr_v_payroll_action_id
2107: AND ppa.payroll_action_id=pai.action_context_id
2108: AND pai.action_context_type = 'PA'

Line 2157: pay_payroll_actions ppa

2153: pay_action_information pai1,
2154: pay_action_information pai2,
2155: pay_action_information pai3,
2156: pay_action_information pai4,
2157: pay_payroll_actions ppa
2158: WHERE
2159: ppa.payroll_action_id=csr_v_payroll_action_id --175110 --175079 --175068 --csr_v_payroll_action_id
2160: AND ppa.payroll_action_id=pai1.action_context_id
2161: AND pai1.action_context_id=pai2.action_context_id

Line 2212: pay_payroll_actions ppa

2208: SELECT nvl(COUNT(*),0) Local_Unit_Count
2209: FROM
2210: pay_action_information pai,
2211: pay_action_information pai1,
2212: pay_payroll_actions ppa
2213: WHERE
2214: ppa.payroll_action_id=csr_v_payroll_action_id --175110 --csr_v_payroll_action_id
2215: AND ppa.payroll_action_id=pai.action_context_id
2216: AND pai.action_context_id=pai1.action_context_id

Line 2290: FROM pay_payroll_actions ppa,

2286: IF p_payroll_action_id IS NULL THEN
2287: BEGIN
2288: SELECT payroll_action_id
2289: INTO l_payroll_action_id
2290: FROM pay_payroll_actions ppa,
2291: fnd_conc_req_summary_v fcrs,
2292: fnd_conc_req_summary_v fcrs1
2293: WHERE fcrs.request_id = fnd_global.conc_request_id
2294: AND fcrs.priority_request_id = fcrs1.priority_request_id