APPS.PAY_SE_EMPLOYMENT_STATISTICS dependencies on PAY_PAYROLL_ACTIONS

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

44: , p_segment_number IN NUMBER DEFAULT NULL
45: )
46: RETURN VARCHAR2
47: IS
48: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
49: l_start_pos NUMBER;
50: l_delimiter VARCHAR2 (1) := ' ';
51: l_proc VARCHAR2 (240) := g_package || ' get parameter ';
52: BEGIN

Line 157: FROM pay_payroll_actions

153: , 'REPORTING_DATE'
154: )
155: )REPORTING_DATE
156: , effective_date effective_date, business_group_id bg_id
157: FROM pay_payroll_actions
158: WHERE payroll_action_id = p_payroll_action_id;
159:
160: lr_parameter_info csr_parameter_info%ROWTYPE;
161: l_proc VARCHAR2 (240)

Line 263: FROM pay_payroll_actions appa

259: , csr_v_canonical_end_date DATE
260: )
261: IS
262: SELECT '1'
263: FROM pay_payroll_actions appa
264: , pay_assignment_actions act
265: , per_all_assignments_f as1
266: , pay_payroll_actions ppa
267: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 266: , pay_payroll_actions ppa

262: SELECT '1'
263: FROM pay_payroll_actions appa
264: , pay_assignment_actions act
265: , per_all_assignments_f as1
266: , pay_payroll_actions ppa
267: WHERE ppa.payroll_action_id = p_payroll_action_id
268: AND appa.effective_date BETWEEN csr_v_canonical_start_date
269: AND csr_v_canonical_end_date
270: AND appa.action_type IN ('R', 'Q')

Line 566: ,pay_payroll_actions ppa

562:
563: p_sql :=
564: 'SELECT DISTINCT person_id
565: FROM per_people_f ppf
566: ,pay_payroll_actions ppa
567: WHERE ppa.payroll_action_id = :payroll_action_id
568: AND ppa.business_group_id = ppf.business_group_id
569: ORDER BY ppf.person_id';
570: g_payroll_action_id := p_payroll_action_id;

Line 2065: FROM pay_payroll_actions ppa

2061: THEN
2062: BEGIN
2063: SELECT payroll_action_id
2064: INTO l_payroll_action_id
2065: FROM pay_payroll_actions ppa
2066: , fnd_conc_req_summary_v fcrs
2067: , fnd_conc_req_summary_v fcrs1
2068: WHERE fcrs.request_id = fnd_global.conc_request_id
2069: AND fcrs.priority_request_id = fcrs1.priority_request_id

Line 2225: pay_payroll_actions ppa,

2221: pai1.action_information25 Terminate_Temporary_Men,
2222: pai1.action_information26 Terminate_Temporary_Women
2223: FROM
2224: pay_action_information pai,
2225: pay_payroll_actions ppa,
2226: pay_action_information pai1
2227: WHERE
2228: pai.action_context_id = ppa.payroll_action_id
2229: AND ppa.payroll_action_id =p_payroll_action_id --20162 --20264 --20165

Line 2248: pay_payroll_actions ppa,

2244: sum(pai1.action_information10) Regular_Women,
2245: sum(pai1.action_information11) Temporary_Men,
2246: sum(pai1.action_information12) Temporary_Women
2247: FROM
2248: pay_payroll_actions ppa,
2249: pay_action_information pai1
2250: WHERE
2251: pai1.action_context_id = ppa.payroll_action_id
2252: AND ppa.payroll_action_id =p_payroll_action_id

Line 2325: FROM pay_payroll_actions ppa,

2321: IF p_payroll_action_id IS NULL THEN
2322: BEGIN
2323: SELECT payroll_action_id
2324: INTO l_payroll_action_id
2325: FROM pay_payroll_actions ppa,
2326: fnd_conc_req_summary_v fcrs,
2327: fnd_conc_req_summary_v fcrs1
2328: WHERE fcrs.request_id = fnd_global.conc_request_id
2329: AND fcrs.priority_request_id = fcrs1.priority_request_id