[Home] [Help]
741: */
742:
743: select pay_magtape_generic.get_parameter_value('TRANSFER_EE_JD_CODE')
744: into p_jurisdiction_code
745: from dual;
746:
747: HR_UTILITY_TRACE('Prameter Used for Employee level XML');
748: HR_UTILITY_TRACE('p_tax_unit_id :'||to_char(p_tax_unit_id));
749: HR_UTILITY_TRACE('p_payroll_action_id :'||to_char(p_payroll_action_id));
943: where ppa.payroll_action_id=p_pactid;
944:
945: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid
946: ,'TRANSFER_PERIOD_TYPE') into l_period_type
947: from dual;
948:
949: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid
950: ,'TRANSFER_TRANS_LEGAL_CO_ID') into l_transmitter
951: from dual;
947: from dual;
948:
949: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid
950: ,'TRANSFER_TRANS_LEGAL_CO_ID') into l_transmitter
951: from dual;
952:
953: IF l_period_type <> 'Yearly' then
954: --Get a list of all GREs under pay_us_asg_reporting which have assignments with PSD Tax deductions.
955: open c_get_gre;
1265: hr_utility.trace('l_transfer_month_quarter: '||l_transfer_month_quarter);
1266:
1267: SELECT decode(l_tax_coll_dist_code,NULL,'ALL','0'||l_tax_coll_dist_code)
1268: INTO l_tax_coll_dist_code_or_all
1269: FROM dual;
1270:
1271: hr_utility.trace('l_tax_coll_dist_code_or_all: '||l_tax_coll_dist_code_or_all);
1272:
1273: SELECT report_file_name
1983: -- combination.
1984: --
1985: select pay_assignment_actions_s.nextval
1986: into lockingactid
1987: from dual;
1988: hr_utility.set_location ('action_creation',8);
1989:
1990: /*SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)
1991: INTO l_transfer_gre_id
2058: l_flag varchar2(1);
2059:
2060: cursor c_chk_payroll_action is
2061: select 'Y'
2062: from dual
2063: where exists (select null
2064: from ff_archive_items fai
2065: where fai.context1 = p_payroll_action_id
2066: and archive_type = 'PPA');