APPS.PAY_NO_HOLIDAY_ENT_REPORT dependencies on PAY_ACTION_INFORMATION

Line 42: l_payroll_action_id pay_action_information.action_information1%TYPE;

38: /* Start of declaration*/
39: -- Variables needed for the report
40: l_sum NUMBER;
41: l_counter NUMBER := 1;
42: l_payroll_action_id pay_action_information.action_information1%TYPE;
43: l_legal_employer_id number;
44: l_legal_employer HR_ORGANIZATION_UNITS.name%type;
45: l_eff_date date;
46: CURSOR csr_legal_employer is select o.name,fnd_date.canonical_to_date(pai.action_information4) from

Line 49: pay_action_information pai

45: l_eff_date date;
46: CURSOR csr_legal_employer is select o.name,fnd_date.canonical_to_date(pai.action_information4) from
47: HR_ORGANIZATION_UNITS o,
48: HR_ORGANIZATION_INFORMATION hoi1,
49: pay_action_information pai
50: where pai.action_context_id = l_payroll_action_id
51: and pai.action_information_category ='EMEA REPORT DETAILS'
52: and o.organization_id = pai.action_information2
53: and hoi1.organization_id = o.organization_id

Line 71: FROM pay_action_information pai

67: pai.action_information7 holiday_taken_days,
68: pai.action_information8 holiday_taken_60_days,
69: pai.action_information9 holiday_remaining_days,
70: pai.action_information10 holiday_remaining60_days
71: FROM pay_action_information pai
72: ,pay_assignment_actions paa
73: WHERE pai.action_context_id = paa.assignment_action_id
74: AND paa.payroll_action_id = csr_v_pa_id
75: AND action_information_category ='EMEA REPORT INFORMATION'