DBA Data[Home] [Help]

APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PAY_CORE_UTILS

Line 300: SELECT pay_core_utils.get_parameter('PAYROLL_ID'

296: l_financial_year VARCHAR2(30);
297: --
298: CURSOR csr_get_parameters(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
299: IS
300: SELECT pay_core_utils.get_parameter('PAYROLL_ID'
301: ,legislative_parameters) payroll_id,
302: pay_core_utils.get_parameter('ASSIGNMENT_SET'
303: ,legislative_parameters) assignment_set_id,
304: pay_core_utils.get_parameter('BUSINESS_GROUP_ID'

Line 302: pay_core_utils.get_parameter('ASSIGNMENT_SET'

298: CURSOR csr_get_parameters(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
299: IS
300: SELECT pay_core_utils.get_parameter('PAYROLL_ID'
301: ,legislative_parameters) payroll_id,
302: pay_core_utils.get_parameter('ASSIGNMENT_SET'
303: ,legislative_parameters) assignment_set_id,
304: pay_core_utils.get_parameter('BUSINESS_GROUP_ID'
305: ,legislative_parameters) business_group_id,
306: pay_core_utils.get_parameter('FINANCIAL_YEAR'

Line 304: pay_core_utils.get_parameter('BUSINESS_GROUP_ID'

300: SELECT pay_core_utils.get_parameter('PAYROLL_ID'
301: ,legislative_parameters) payroll_id,
302: pay_core_utils.get_parameter('ASSIGNMENT_SET'
303: ,legislative_parameters) assignment_set_id,
304: pay_core_utils.get_parameter('BUSINESS_GROUP_ID'
305: ,legislative_parameters) business_group_id,
306: pay_core_utils.get_parameter('FINANCIAL_YEAR'
307: ,legislative_parameters) financial_year,
308: pay_core_utils.get_parameter('PROCESSING_MODE'

Line 306: pay_core_utils.get_parameter('FINANCIAL_YEAR'

302: pay_core_utils.get_parameter('ASSIGNMENT_SET'
303: ,legislative_parameters) assignment_set_id,
304: pay_core_utils.get_parameter('BUSINESS_GROUP_ID'
305: ,legislative_parameters) business_group_id,
306: pay_core_utils.get_parameter('FINANCIAL_YEAR'
307: ,legislative_parameters) financial_year,
308: pay_core_utils.get_parameter('PROCESSING_MODE'
309: ,legislative_parameters) processing_mode
310: FROM pay_payroll_actions ppa

Line 308: pay_core_utils.get_parameter('PROCESSING_MODE'

304: pay_core_utils.get_parameter('BUSINESS_GROUP_ID'
305: ,legislative_parameters) business_group_id,
306: pay_core_utils.get_parameter('FINANCIAL_YEAR'
307: ,legislative_parameters) financial_year,
308: pay_core_utils.get_parameter('PROCESSING_MODE'
309: ,legislative_parameters) processing_mode
310: FROM pay_payroll_actions ppa
311: WHERE ppa.payroll_action_id = p_payroll_action_id;
312: