DBA Data[Home] [Help]

APPS.PAY_US_PSD_XML dependencies on PAY_US_PAYROLL_UTILS

Line 1246: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_TRANS_LEGAL_CO_ID',legislative_parameters)

1242: update pay_payroll_actions
1243: set effective_date = l_period_end
1244: WHERE payroll_action_id = p_pactid;
1245:
1246: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_TRANS_LEGAL_CO_ID',legislative_parameters)
1247: INTO l_trans_legal_co_id
1248: FROM pay_payroll_actions
1249: WHERE payroll_action_id = p_pactid;
1250:

Line 1260: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_MONTH/QUARTER',legislative_parameters)

1256: WHERE organization_id = l_trans_legal_co_id;
1257:
1258: hr_utility.trace('Transmitter Name l_gre_name: '||l_gre_name);
1259:
1260: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_MONTH/QUARTER',legislative_parameters)
1261: INTO l_transfer_month_quarter
1262: FROM pay_payroll_actions
1263: WHERE payroll_action_id = p_pactid;
1264:

Line 1990: /*SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)

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
1992: FROM pay_payroll_actions
1993: WHERE payroll_action_id = p_pactid;
1994: hr_utility.trace('In action_creation, l_transfer_gre_id= '||l_transfer_gre_id);*/