DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 30: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))

26: --Bug 5069923
27: and ( (report_for_var='A')
28: or ( (hoi2.organization_id in (select posev.ORGANIZATION_ID_child
29: from PER_ORG_STRUCTURE_ELEMENTS posev
30: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
31: and exists (select null
32: from hr_organization_information
33: where organization_id = posev.ORGANIZATION_ID_child
34: and org_information_context = 'CLASS'

Line 68: g_business_place_id := to_number(pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID'));

64: and paa.tax_unit_id = bp2.organization_id
65: and paa.action_status = 'C');
66: begin
67: if g_business_place_id is null then
68: g_business_place_id := to_number(pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID'));
69: g_target_year := to_number(pay_magtape_generic.get_parameter_value('TARGET_YEAR'));
70: --Bug 5069923
71: report_for_var := pay_magtape_generic.get_parameter_value('REPORT_FOR');
72: --

Line 69: g_target_year := to_number(pay_magtape_generic.get_parameter_value('TARGET_YEAR'));

65: and paa.action_status = 'C');
66: begin
67: if g_business_place_id is null then
68: g_business_place_id := to_number(pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID'));
69: g_target_year := to_number(pay_magtape_generic.get_parameter_value('TARGET_YEAR'));
70: --Bug 5069923
71: report_for_var := pay_magtape_generic.get_parameter_value('REPORT_FOR');
72: --
73: open csr_a;

Line 71: report_for_var := pay_magtape_generic.get_parameter_value('REPORT_FOR');

67: if g_business_place_id is null then
68: g_business_place_id := to_number(pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID'));
69: g_target_year := to_number(pay_magtape_generic.get_parameter_value('TARGET_YEAR'));
70: --Bug 5069923
71: report_for_var := pay_magtape_generic.get_parameter_value('REPORT_FOR');
72: --
73: open csr_a;
74: fetch csr_a into g_b_records;
75: close csr_a;

Line 149: g_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

145: return l_user_entity_id;
146: end user_entity_id;
147: begin
148: -- Bug 3248513
149: g_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
150: g_assignment_set_id := to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'));
151:
152: if g_payroll_action_id is null then
153:

Line 150: g_assignment_set_id := to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'));

146: end user_entity_id;
147: begin
148: -- Bug 3248513
149: g_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
150: g_assignment_set_id := to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'));
151:
152: if g_payroll_action_id is null then
153:
154: l_report_type := pay_magtape_generic.get_parameter_value('REPORT_TYPE');

Line 154: l_report_type := pay_magtape_generic.get_parameter_value('REPORT_TYPE');

150: g_assignment_set_id := to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'));
151:
152: if g_payroll_action_id is null then
153:
154: l_report_type := pay_magtape_generic.get_parameter_value('REPORT_TYPE');
155:
156: if l_report_type is null then
157: g_normal_yea := 'N';
158: g_interim_yea := 'I';