APPS.PAY_NO_RSER dependencies on PAY_ACTION_INFORMATION

Line 55: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;

51: l_u_zone4 NUMBER;
52: l_o_zone4 NUMBER;
53: l_u_zone5 NUMBER;
54: l_o_zone5 NUMBER;
55: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;
56: l_IANA_charset VARCHAR2 (50);
57: l_el NUMBER;
58:
59: /* End of declaration*/

Line 62: Cursor csr_rser_header_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)

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

Line 65: FROM PAY_ACTION_INFORMATION

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

Line 73: Cursor csr_rser_body_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)

69: AND ACTION_INFORMATION1='PYNORSEA';
70:
71: rg_rser_header_rpt csr_rser_header_rpt%rowtype;
72:
73: Cursor csr_rser_body_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
74: IS
75: SELECT *
76: FROM PAY_ACTION_INFORMATION
77: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 76: FROM PAY_ACTION_INFORMATION

72:
73: Cursor csr_rser_body_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
74: IS
75: SELECT *
76: FROM PAY_ACTION_INFORMATION
77: WHERE ACTION_CONTEXT_TYPE = 'PA'
78: AND ACTION_CONTEXT_ID = csr_v_pa_id
79: AND ACTION_INFORMATION_CATEGORY= 'EMEA REPORT INFORMATION'
80: AND ACTION_INFORMATION1='PYNORSEA'

Line 85: Cursor csr_rser_sum_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)

81: AND ACTION_INFORMATION2='M';
82:
83: rg_rser_body_rpt csr_rser_body_rpt%rowtype;
84:
85: Cursor csr_rser_sum_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
86: IS
87: SELECT SUM(action_information6) Witholding_Tax, SUM(action_information7) u_contribution_basis, SUM(action_information8) o_contribution_basis
88: , SUM(action_information20) fe_spr_contribution_basis, SUM(action_information21) fe_spr_calc_contribution
89: , SUM(action_information25) fe_fma_calc_contribution , SUM(action_information11) u_calc_contribution, SUM(action_information12) o_calc_contribution

Line 91: FROM PAY_ACTION_INFORMATION

87: SELECT SUM(action_information6) Witholding_Tax, SUM(action_information7) u_contribution_basis, SUM(action_information8) o_contribution_basis
88: , SUM(action_information20) fe_spr_contribution_basis, SUM(action_information21) fe_spr_calc_contribution
89: , SUM(action_information25) fe_fma_calc_contribution , SUM(action_information11) u_calc_contribution, SUM(action_information12) o_calc_contribution
90: , SUM(action_information26) lu_el_used , SUM(action_information27) lu_el_used_bimonth , SUM(action_information23) no_month
91: FROM PAY_ACTION_INFORMATION
92: WHERE ACTION_CONTEXT_TYPE = 'PA'
93: AND ACTION_CONTEXT_ID = csr_v_pa_id
94: AND ACTION_INFORMATION_CATEGORY= 'EMEA REPORT INFORMATION'
95: AND ACTION_INFORMATION1='PYNORSEA'