DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_RUN_TYPES_F

Line 5597: from pay_run_types_f prt

5593: and organization_id = cp_business_group;
5594:
5595: cursor c_sepchk_ryn_type is
5596: select prt.run_type_id
5597: from pay_run_types_f prt
5598: where prt.shortname = 'SEPCHECK'
5599: and prt.legislation_code = 'US';
5600:
5601: cursor c_assignment_run (cp_prepayment_action_id in number) is

Line 5665: from pay_run_types_f prt

5661: and paa.assignment_id = cp_assignment_id
5662: and paa.tax_unit_id = cp_tax_unit_id
5663: and paa.source_action_id is not null
5664: and not exists ( select 1
5665: from pay_run_types_f prt
5666: where prt.legislation_code = 'US'
5667: and prt.run_type_id = paa.run_type_id
5668: and prt.run_method in ('C', 'S'))
5669: order by paa.action_sequence desc;

Line 5756: from pay_run_types_f prt

5752: and paa.assignment_id = cp_assignment_id
5753: and paa.tax_unit_id = cp_tax_unit_id
5754: and nvl(paa.run_type_id,0) <> cp_sepchk_run_type
5755: and not exists ( select 1
5756: from pay_run_types_f prt
5757: where prt.legislation_code = 'US'
5758: and prt.run_type_id = nvl(paa.run_type_id,0)
5759: and prt.run_method = 'C' );
5760: