APPS.PAY_NO_ABS_STATISTICS_REPORT dependencies on PAY_ACTION_INFORMATION

Line 45: l_payroll_action_id pay_action_information.action_information1%TYPE;

41: /* Start of declaration*/
42: -- Variables needed for the report
43: l_sum NUMBER;
44: l_counter NUMBER := 1;
45: l_payroll_action_id pay_action_information.action_information1%TYPE;
46: l_legal_employer_id number;
47: l_legal_employer HR_ORGANIZATION_UNITS.name%type;
48: l_quater VARCHAR2(3);
49: l_quater_flag VARCHAR2(2):='Y';

Line 60: pay_action_information pai

56: CURSOR csr_legal_employer is select o.name,fnd_date.canonical_to_date(pai.action_information5) action_information5
57: from
58: HR_ORGANIZATION_UNITS o,
59: HR_ORGANIZATION_INFORMATION hoi1,
60: pay_action_information pai
61: where pai.action_context_id = l_payroll_action_id
62: and pai.action_information_category ='EMEA REPORT DETAILS'
63: and o.organization_id = pai.action_information2
64: and hoi1.organization_id = o.organization_id

Line 93: from pay_action_information pai

89: pai.action_information21 sick_more_8w_days,
90: pai.action_information22 other_abs_paid_ocrs,
91: pai.action_information23 other_abs_paid_days,
92: pai.action_information24 business_group_id
93: from pay_action_information pai
94: where pai.action_context_id = csr_v_pa_id
95: and action_information_category ='EMEA REPORT INFORMATION'
96: and action_information1 = 'PYNOABSA'
97: order by pai.action_information3;