APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on PAY_MAGTAPE_GENERIC

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

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

Line 66: g_business_place_id := to_number(pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID'));

62: and paa.tax_unit_id = bp2.organization_id
63: and paa.action_status = 'C');
64: begin
65: if g_business_place_id is null then
66: g_business_place_id := to_number(pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID'));
67: report_for_var := pay_magtape_generic.get_parameter_value('REPORT_FOR');
68: --
69: open csr_a;
70: fetch csr_a into g_b_records;

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

63: and paa.action_status = 'C');
64: begin
65: if g_business_place_id is null then
66: g_business_place_id := to_number(pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID'));
67: report_for_var := pay_magtape_generic.get_parameter_value('REPORT_FOR');
68: --
69: open csr_a;
70: fetch csr_a into g_b_records;
71: close csr_a;

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

79: l_report_type varchar2(3);
80:
81: begin
82: --
83: g_payroll_action_id := to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') );
84: g_target_year := to_number(pay_magtape_generic.get_parameter_value('TARGET_YEAR'));
85: g_assignment_set_id := to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'));
86: --
87: if g_payroll_action_id is null then

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

80:
81: begin
82: --
83: g_payroll_action_id := to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') );
84: g_target_year := to_number(pay_magtape_generic.get_parameter_value('TARGET_YEAR'));
85: g_assignment_set_id := to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'));
86: --
87: if g_payroll_action_id is null then
88:

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

81: begin
82: --
83: g_payroll_action_id := to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') );
84: g_target_year := to_number(pay_magtape_generic.get_parameter_value('TARGET_YEAR'));
85: g_assignment_set_id := to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'));
86: --
87: if g_payroll_action_id is null then
88:
89: l_report_type := pay_magtape_generic.get_parameter_value('REPORT_TYPE');

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

85: g_assignment_set_id := to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'));
86: --
87: if g_payroll_action_id is null then
88:
89: l_report_type := pay_magtape_generic.get_parameter_value('REPORT_TYPE');
90:
91: if l_report_type is null then
92: g_normal_yea := 'N';
93: g_interim_yea := 'I';