DBA Data[Home] [Help]

APPS.PAY_US_SQWL_GRE dependencies on PAY_CORE_UTILS

Line 250: AND pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters) = c_get_all_gres_rec.organization_id;

246: WHERE report_type = 'SQWL'
247: AND report_qualifier = p_state
248: AND business_group_id = p_business_group_id
249: AND effective_date = fnd_date.canonical_to_date (p_effective_date)
250: AND pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters) = c_get_all_gres_rec.organization_id;
251:
252: hr_utility.trace('l_previous_sqwl_run_check: '||l_previous_sqwl_run_check);
253:
254: select count(paa.assignment_action_id)

Line 793: AND pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters) = c_get_all_gres_rec.organization_id;

789: WHERE report_type = 'SMWL'
790: AND report_qualifier = p_state
791: AND business_group_id = p_business_group_id
792: AND effective_date = fnd_date.canonical_to_date (p_effective_date)
793: AND pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters) = c_get_all_gres_rec.organization_id;
794:
795: hr_utility.trace('l_previous_smwl_run_check: '||l_previous_smwl_run_check);
796:
797: select count(paa.assignment_action_id)