APPS.PAY_FI_UMFR dependencies on PAY_ACTION_INFORMATION

Line 47: l_payroll_action_id pay_action_information.action_information1%TYPE;

43:
44: -- Variables needed for the report
45: l_sum NUMBER;
46: l_counter NUMBER := 1;
47: l_payroll_action_id pay_action_information.action_information1%TYPE;
48:
49: cursor first_level(csr_v_pa_id IN VARCHAR2) is
50: select ACTION_INFORMATION2 TRADE_UNION_NAME, ACTION_INFORMATION4 LEGAL_EMPLOYER_NAME
51: from pay_action_information pai where

Line 51: from pay_action_information pai where

47: l_payroll_action_id pay_action_information.action_information1%TYPE;
48:
49: cursor first_level(csr_v_pa_id IN VARCHAR2) is
50: select ACTION_INFORMATION2 TRADE_UNION_NAME, ACTION_INFORMATION4 LEGAL_EMPLOYER_NAME
51: from pay_action_information pai where
52: pai.action_information_category = 'EMEA REPORT DETAILS'
53: AND pai.action_context_type = 'PA'
54: AND PAI.ACTION_CONTEXT_ID=csr_v_pa_id;
55:

Line 59: from pay_action_information pai where

55:
56: first_level_rec first_level%rowtype;
57: cursor legal_header(csr_v_pa_id IN VARCHAR2) is
58: select ACTION_INFORMATION2 TRADE_UNION_NAME, ACTION_INFORMATION4 LEGAL_EMPLOYER_NAME
59: from pay_action_information pai where
60: pai.action_information_category = 'EMEA REPORT DETAILS'
61: AND pai.action_context_type = 'PA'
62: AND PAI.ACTION_CONTEXT_ID=csr_v_pa_id;
63: legal_header_rec legal_header%rowtype;

Line 68: from pay_action_information pai where

64:
65:
66: cursor local_header(csr_v_pa_id IN VARCHAR2) is
67: select ACTION_INFORMATION2 TRADE_UNION_NAME, ACTION_INFORMATION4 LEGAL_EMPLOYER_NAME
68: from pay_action_information pai where
69: pai.action_information_category = 'EMEA REPORT DETAILS'
70: AND pai.action_context_type = 'PA'
71: AND PAI.ACTION_CONTEXT_ID=csr_v_pa_id;
72: local_header_rec legal_header%rowtype;

Line 97: pay_action_information pai,

93: pai_per.action_information9
94: SIGN, pai_per.action_information8 amount,
95: '00' reason, to_char(fnd_date.canonical_to_date(pai.action_information9),'RRRR') tax_year, NULL sequence_number
96: FROM pay_assignment_actions asgact, -- pay_payroll_actions payact,
97: pay_action_information pai,
98: pay_action_information pai_per,
99: pay_action_information pai_lu,
100: pay_action_information pai_le,
101: pay_action_information pai_tu

Line 98: pay_action_information pai_per,

94: SIGN, pai_per.action_information8 amount,
95: '00' reason, to_char(fnd_date.canonical_to_date(pai.action_information9),'RRRR') tax_year, NULL sequence_number
96: FROM pay_assignment_actions asgact, -- pay_payroll_actions payact,
97: pay_action_information pai,
98: pay_action_information pai_per,
99: pay_action_information pai_lu,
100: pay_action_information pai_le,
101: pay_action_information pai_tu
102: WHERE asgact.payroll_action_id = csr_v_pa_id

Line 99: pay_action_information pai_lu,

95: '00' reason, to_char(fnd_date.canonical_to_date(pai.action_information9),'RRRR') tax_year, NULL sequence_number
96: FROM pay_assignment_actions asgact, -- pay_payroll_actions payact,
97: pay_action_information pai,
98: pay_action_information pai_per,
99: pay_action_information pai_lu,
100: pay_action_information pai_le,
101: pay_action_information pai_tu
102: WHERE asgact.payroll_action_id = csr_v_pa_id
103: AND pai_per.action_context_type = 'AAP'

Line 100: pay_action_information pai_le,

96: FROM pay_assignment_actions asgact, -- pay_payroll_actions payact,
97: pay_action_information pai,
98: pay_action_information pai_per,
99: pay_action_information pai_lu,
100: pay_action_information pai_le,
101: pay_action_information pai_tu
102: WHERE asgact.payroll_action_id = csr_v_pa_id
103: AND pai_per.action_context_type = 'AAP'
104: AND pai_per.action_information1 = 'PYFIUMFR'

Line 101: pay_action_information pai_tu

97: pay_action_information pai,
98: pay_action_information pai_per,
99: pay_action_information pai_lu,
100: pay_action_information pai_le,
101: pay_action_information pai_tu
102: WHERE asgact.payroll_action_id = csr_v_pa_id
103: AND pai_per.action_context_type = 'AAP'
104: AND pai_per.action_information1 = 'PYFIUMFR'
105: AND pai_per.action_information_category = 'EMEA REPORT INFORMATION'