APPS.PAY_SE_HCIR dependencies on PAY_ACTION_INFORMATION

Line 11: csr_v_pa_id pay_action_information.action_context_id%TYPE

7: p_xml OUT NOCOPY CLOB
8: ) IS
9: --Cursors needed for report
10: CURSOR csr_all_legal_employer (
11: csr_v_pa_id pay_action_information.action_context_id%TYPE
12: ) IS
13: SELECT action_information4 legal_employer_name, action_information5 org_number,
14: fnd_date.canonical_to_date(action_information6) curr_start_date,
15: fnd_date.canonical_to_date (action_information7)curr_end_date,

Line 24: FROM pay_action_information

20: fnd_number.canonical_to_number (action_information11) curr_avg_women_count,
21: fnd_number.canonical_to_number (action_information12)
22: prev_avg_men_count,
23: fnd_number.canonical_to_number (action_information13) prev_avg_women_count, effective_date
24: FROM pay_action_information
25: WHERE action_context_type = 'PA'
26: AND action_context_id = csr_v_pa_id
27: AND action_information_category = 'EMEA REPORT INFORMATION'
28: AND action_information1 = 'PYSEHCIA'

Line 31: l_payroll_action_id pay_action_information.action_information1%TYPE;

27: AND action_information_category = 'EMEA REPORT INFORMATION'
28: AND action_information1 = 'PYSEHCIA'
29: AND action_information2 = 'LE';
30:
31: l_payroll_action_id pay_action_information.action_information1%TYPE;
32: l_counter NUMBER := 0;
33: BEGIN
34: IF p_payroll_action_id IS NULL THEN
35: BEGIN