APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 30: FROM pay_assignment_actions paa

26: SELECT paa.assignment_action_id
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')

Line 56: FROM pay_assignment_actions paa

52: ,c_start_date IN Date
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')

Line 606: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

602: ,p_end_date IN DATE
603: ,p_balance_name IN pay_balance_types.balance_name%TYPE
604: ,p_dim_name IN VARCHAR2) RETURN NUMBER IS
605:
606: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
607: l_balance_id pay_balance_types.balance_type_id%TYPE;
608: l_balance_amount NUMBER := 0;
609: l_dim_name VARCHAR2(100);
610:

Line 626: FROM pay_assignment_actions paa

622: , '0')
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')

Line 2471: FROM pay_assignment_actions paa

2467: ,c_start_date IN DATE
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'

Line 2575: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;

2571: ,p_org_id IN NUMBER)
2572: IS
2573: l_asg_act_id NUMBER;
2574: BEGIN
2575: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;
2576: hr_nonrun_asact.insact(
2577: lockingactid => l_asg_act_id
2578: ,assignid => p_assignid
2579: ,pactid => p_pactid

Line 2735: ,pay_assignment_actions paa

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: --=========================================================================
2739: -- Assignment Sequence

Line 2765: ,pay_assignment_actions paa

2761: ,c_payroll_action_id IN NUMBER) IS
2762: SELECT DISTINCT
2763: paa.assignment_id
2764: FROM per_all_assignments_f paaf
2765: ,pay_assignment_actions paa
2766: WHERE paa.payroll_action_id = c_payroll_action_id
2767: AND paa.assignment_action_id = c_asg_action_id
2768: AND paaf.assignment_id = paa.assignment_id;
2769: --=========================================================================

Line 3188: FROM pay_assignment_actions paa

3184: FROM dual
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')

Line 3849: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;

3845: END IF;
3846:
3847: hr_utility.trace('Payroll Id : ' ||l_payroll_id);
3848:
3849: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
3850:
3851: hr_nonrun_asact.insact(
3852: lockingactid => l_child_aa_id
3853: , assignid => l_assignment_id

Line 4609: FROM pay_assignment_actions paa

4605: ,pai_p.action_information6 Description
4606: ,substr(pai_p.action_information7,1,45) E_Name
4607: ,substr(pai_p.action_information8,1,30) E_Number
4608: ,pai_p.action_context_type cxt
4609: FROM pay_assignment_actions paa
4610: ,pay_action_information pai_p
4611: WHERE paa.payroll_action_id = p_payroll_action_id
4612: AND pai_p.action_context_id = paa.assignment_action_id
4613: AND pai_p.action_information_category = 'NL_ABP_EXCEPTION_REPORT'