APPS.PAY_FI_MTRR dependencies on PAY_ACTION_INFORMATION

Line 22: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;

18: l_no_vat_month VARCHAR2(30);
19: l_due_date VARCHAR2(30);
20: l_sum VARCHAR2(30);
21: l_counter number := 0;
22: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;
23: l_x80_code VARCHAR2(30);
24: l_x81_code VARCHAR2(30);
25: l_x82_code VARCHAR2(30);
26: l_sal_subject_wt VARCHAR2(30);

Line 61: Cursor csr_mtrr_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)

57:
58: /* End of declaration*/
59:
60: /* Cursors */
61: Cursor csr_mtrr_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
62: IS
63: SELECT *
64: FROM PAY_ACTION_INFORMATION
65: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 64: FROM PAY_ACTION_INFORMATION

60: /* Cursors */
61: Cursor csr_mtrr_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
62: IS
63: SELECT *
64: FROM PAY_ACTION_INFORMATION
65: WHERE ACTION_CONTEXT_TYPE = 'PA'
66: AND ACTION_CONTEXT_ID = csr_v_pa_id
67: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION' ;
68: