APPS.PAY_FI_DPSR dependencies on PAY_ASSIGNMENT_ACTIONS

Line 22: FROM pay_action_information pai , pay_assignment_actions paa

18: /* Cursors */
19: /* Cursor to fetch data related to Record 1 of VSPSERIE*/
20: CURSOR csr_VSPSERIE1 (p_payroll_action_id NUMBER) IS
21: SELECT pai.*
22: FROM pay_action_information pai , pay_assignment_actions paa
23: WHERE paa.payroll_action_id = p_payroll_action_id
24: AND pai.action_context_id= paa.assignment_action_id
25: AND pai.action_context_type= 'AAP'
26: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 35: FROM pay_action_information pai , pay_assignment_actions paa

31:
32: /* Cursor to fetch data related to Record 2 of VSPSERIE*/
33: CURSOR csr_VSPSERIE2 (p_payroll_action_id NUMBER, p_action_context_id NUMBER) IS
34: SELECT pai.*
35: FROM pay_action_information pai , pay_assignment_actions paa
36: WHERE paa.payroll_action_id = p_payroll_action_id
37: AND pai.action_context_id= paa.assignment_action_id
38: AND pai.action_context_type= 'AAP'
39: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 52: FROM pay_action_information pai , pay_assignment_actions paa

48:
49: /* Cursor to fetch data related to Record VSRAERIE*/
50: CURSOR csr_VSRAERIE(p_payroll_action_id NUMBER) IS
51: SELECT pai.*
52: FROM pay_action_information pai , pay_assignment_actions paa
53: WHERE paa.payroll_action_id = p_payroll_action_id
54: AND pai.action_context_id= paa.assignment_action_id
55: AND pai.action_context_type= 'AAP'
56: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 64: FROM pay_action_information pai , pay_assignment_actions paa

60:
61: /* Cursor to fetch data related to Record VSPSTUKI*/
62: CURSOR csr_VSPSTUKI(p_payroll_action_id NUMBER) IS
63: SELECT pai.*
64: FROM pay_action_information pai , pay_assignment_actions paa
65: WHERE paa.payroll_action_id = p_payroll_action_id
66: AND pai.action_context_id= paa.assignment_action_id
67: AND pai.action_context_type= 'AAP'
68: AND pai.action_information_category = 'EMEA REPORT INFORMATION'