APPS.PAY_NO_SELF_CERTIFICATION_RPT 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:

Line 50: pay_action_information pai

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

Line 66: FROM pay_action_information pai

62: pai.action_information1,
63: pai.action_information2 employee_number,
64: pai.action_information3 full_name,
65: pai.action_information4 sc_days
66: FROM pay_action_information pai
67: ,pay_assignment_actions paa
68: WHERE pai.action_context_id = paa.assignment_action_id
69: AND paa.payroll_action_id = csr_v_pa_id
70: AND action_information_category ='EMEA REPORT INFORMATION'