APPS.PAY_KR_YEA_CONC_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 9: P_payroll_id pay_payroll_actions.payroll_id%type,

5: RETCODE OUT NOCOPY VARCHAR2,
6: P_yea_Type VARCHAR2,
7: P_effective_date VARCHAR2,
8: P_business_group_id per_all_people_f.business_group_id%type,
9: P_payroll_id pay_payroll_actions.payroll_id%type,
10: P_action_parameter_group_id pay_action_parameter_groups.action_parameter_group_id%type,
11: P_consolidation_set_id pay_consolidation_sets.consolidation_set_id%type,
12: P_assignment_set_id hr_assignment_sets.assignment_set_id%type,
13: P_element_type_iD pay_element_types.element_type_id%type,

Line 19: l_bal_adj_action_id pay_payroll_actions.payroll_action_id%type;

15: )
16: IS
17: l_bal_req_id NUMBER;
18: l_arc_req_id NUMBER;
19: l_bal_adj_action_id pay_payroll_actions.payroll_action_id%type;
20: l_effective_date DATE ;
21: l_message VARCHAR2(2000);
22: l_phase VARCHAR2(100);
23: l_status VARCHAR2(100);

Line 31: FROM pay_payroll_actions

27:
28: CURSOR csr_bal_adj_action_id
29: IS
30: SELECT payroll_action_id
31: FROM pay_payroll_actions
32: WHERE request_id = l_bal_req_id
33: AND payroll_id = p_payroll_id
34: AND consolidation_set_id = p_consolidation_set_id
35: AND effective_date = l_effective_date;