DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_RUN_TYPES_F

Line 603: from pay_run_types_f prt,

599: ,p_effective_date date
600: ) is
601: select upper(prt.run_type_name) run_type_name,
602: prt.run_type_id
603: from pay_run_types_f prt,
604: per_business_groups_perf pbg
605: where pbg.business_group_id = p_business_group_id
606: and p_effective_date between prt.effective_start_date
607: and prt.effective_end_date

Line 617: from pay_run_types_f prt,

613: and p_run_type_id is not null
614: union all
615: select upper(prt.run_type_name) run_type_name,
616: prt.run_type_id
617: from pay_run_types_f prt,
618: per_business_groups_perf pbg
619: where pbg.business_group_id = p_business_group_id
620: and p_effective_date between prt.effective_start_date
621: and prt.effective_end_date