APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 31: ,pay_payroll_actions ppa

27: ,ppa.effective_date
28: ,ppa.action_type
29: ,ppa.date_earned
30: FROM pay_assignment_actions paa
31: ,pay_payroll_actions ppa
32: WHERE paa.assignment_id = c_assignment_id
33: AND ppa.action_status = 'C'
34: AND paa.action_status IN ('C','S')
35: AND ppa.action_type IN ('Q','R')

Line 57: ,pay_payroll_actions ppa

53: ,c_end_date IN Date
54: ) IS
55: SELECT max (paa.assignment_action_id)
56: FROM pay_assignment_actions paa
57: ,pay_payroll_actions ppa
58: WHERE paa.assignment_id = c_assignment_id
59: AND ppa.action_status = 'C'
60: AND ppa.action_type IN ('Q','R')
61: AND paa.action_status IN ('C','S')

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

325: ,p_token IN VARCHAR2
326: ,p_segment_number IN NUMBER DEFAULT NULL )
327: RETURN VARCHAR2 IS
328:
329: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
330: l_start_pos NUMBER;
331: l_delimiter varchar2(1):=' ';
332:
333: BEGIN

Line 383: FROM pay_payroll_actions

379: ,'Sequence_Number')) seq_num
380: ,business_group_id bg_id
381: ,start_date
382: ,effective_date
383: FROM pay_payroll_actions
384: WHERE payroll_action_id = c_payroll_action_id;
385:
386: l_param csr_parameter_info%ROWTYPE;
387:

Line 627: , pay_payroll_actions ppa

623: || lpad (paa.assignment_action_id, 15
624: , '0')), 16
625: , 15))
626: FROM pay_assignment_actions paa
627: , pay_payroll_actions ppa
628: WHERE paa.assignment_id = c_assignment_id
629: AND ppa.action_status = 'C'
630: AND paa.action_status IN ('C', 'S')
631: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2285: ,pay_payroll_actions ppa

2281: g_payroll_action_id := pactid; --14793405
2282:
2283: sqlstr := 'SELECT DISTINCT person_id
2284: FROM per_all_people_f pap
2285: ,pay_payroll_actions ppa
2286: WHERE ppa.payroll_action_id = :payroll_action_id
2287: AND ppa.business_group_id = pap.business_group_id
2288: ORDER BY pap.person_id';
2289:

Line 2336: FROM pay_payroll_actions

2332: --=========================================================================
2333: CURSOR csr_bg_stdate(p_payroll_action_id IN NUMBER) IS
2334: SELECT business_group_id bg_id
2335: ,start_date start_date
2336: FROM pay_payroll_actions
2337: WHERE payroll_action_id = p_payroll_action_id;
2338: --=========================================================================
2339: l_user_table_id NUMBER;
2340: l_user_column_id NUMBER;

Line 2374: FROM pay_payroll_actions ppa

2370: ,c_end_date IN DATE) IS
2371: SELECT DISTINCT
2372: paa.assignment_id assignment_id
2373: ,paa.person_id
2374: FROM pay_payroll_actions ppa
2375: ,per_org_structure_versions posv
2376: ,per_all_assignments_f paa
2377: ,per_all_people_f pap
2378: WHERE posv.organization_structure_id = c_org_struct_id

Line 2472: ,pay_payroll_actions ppa

2468: ,c_end_date IN DATE)
2469: IS
2470: SELECT 1
2471: FROM pay_assignment_actions paa
2472: ,pay_payroll_actions ppa
2473: WHERE paa.assignment_id = c_asg_id
2474: AND ppa.BUSINESS_GROUP_ID = c_bg_id
2475: AND ppa.action_status = 'C'
2476: AND ppa.action_type IN ('Q','R')

Line 2734: FROM pay_payroll_actions ppa

2730:
2731: CURSOR csr_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS
2732: SELECT ppa.payroll_action_id
2733: ,paa.chunk_number
2734: FROM pay_payroll_actions ppa
2735: ,pay_assignment_actions paa
2736: WHERE paa.payroll_action_id = ppa.payroll_action_id
2737: AND paa.assignment_action_id = c_assignment_action_id;
2738: --=========================================================================

Line 3189: , pay_payroll_actions ppa

3185: UNION
3186: --to find the late hire scenarios paid in current period
3187: SELECT ppa.date_earned
3188: FROM pay_assignment_actions paa
3189: , pay_payroll_actions ppa
3190: WHERE paa.assignment_id = c_assignment_id
3191: AND ppa.action_status = 'C'
3192: AND paa.action_status IN ('C', 'S')
3193: AND ppa.action_type IN ('Q', 'R')