APPS.PAY_FI_LTFR dependencies on PAY_ACTION_INFORMATION

Line 16: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;

12: /* Start of declaration*/
13:
14: -- Variables needed for the report
15: l_counter number := 0;
16: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;
17: L_SALARY number;
18: l_sr_no NUMBER ;
19:
20: /* End of declaration*/

Line 23: Cursor csr_ltfr_header_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)

19:
20: /* End of declaration*/
21:
22: /* Cursors */
23: Cursor csr_ltfr_header_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)
24: IS
25: SELECT *
26: FROM PAY_ACTION_INFORMATION
27: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 26: FROM PAY_ACTION_INFORMATION

22: /* Cursors */
23: Cursor csr_ltfr_header_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)
24: IS
25: SELECT *
26: FROM PAY_ACTION_INFORMATION
27: WHERE ACTION_CONTEXT_TYPE = 'PA'
28: AND ACTION_CONTEXT_ID = csr_v_pa_id
29: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT DETAILS';
30:

Line 33: Cursor csr_ltfr_body_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)

29: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT DETAILS';
30:
31: rg_ltfr_header_rpt csr_ltfr_header_rpt%rowtype;
32:
33: Cursor csr_ltfr_body_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
34: IS
35: SELECT *
36: FROM PAY_ACTION_INFORMATION
37: WHERE ACTION_CONTEXT_TYPE = 'AAP'

Line 36: FROM PAY_ACTION_INFORMATION

32:
33: Cursor csr_ltfr_body_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
34: IS
35: SELECT *
36: FROM PAY_ACTION_INFORMATION
37: WHERE ACTION_CONTEXT_TYPE = 'AAP'
38: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'
39: AND ACTION_INFORMATION2='PER'
40: AND ACTION_INFORMATION10=csr_v_pa_id