APPS.PAY_CA_PAYROLL_ARCH dependencies on PAY_RUN_TYPES_F

Line 701: from pay_run_types_f prt

697: and paa.assignment_id = cp_assignment_id
698: and ppa.payroll_action_id = paa.payroll_action_id
699: and nvl(paa.run_type_id,0) <> cp_sepchk_run_type
700: and not exists ( select 1
701: from pay_run_types_f prt
702: where prt.legislation_code = 'CA'
703: and prt.run_type_id = nvl(paa.run_type_id,0)
704: and prt.run_method = 'C' )
705: and ((paa.source_action_id is not null) OR

Line 725: from pay_run_types_f prt

721: and paa.tax_unit_id = cp_tax_unit_id
722: and ppa.payroll_action_id = paa.payroll_action_id
723: and nvl(paa.run_type_id,0) <> cp_sepchk_run_type
724: and not exists ( select 1
725: from pay_run_types_f prt
726: where prt.legislation_code = 'CA'
727: and prt.run_type_id = nvl(paa.run_type_id,0)
728: and prt.run_method = 'C' )
729: and paa.source_action_id is not null

Line 1173: from pay_run_types_f prt

1169: and paa.assignment_id = cp_assignment_id
1170: and paa.tax_unit_id = cp_tax_unit_id
1171: and nvl(paa.run_type_id,0) <> cp_sepchk_run_type
1172: and not exists ( select 1
1173: from pay_run_types_f prt
1174: where prt.legislation_code = 'CA'
1175: and prt.run_type_id = nvl(paa.run_type_id,0)
1176: and prt.run_method = 'C' );
1177:

Line 1506: from pay_run_types_f prt

1502: and paa.assignment_id = cp_assignment_id
1503: and paa.tax_unit_id = cp_tax_unit_id
1504: and nvl(paa.run_type_id,0) <> cp_sepchk_run_type
1505: and not exists ( select 1
1506: from pay_run_types_f prt
1507: where prt.legislation_code = 'CA'
1508: and prt.run_type_id = nvl(paa.run_type_id,0)
1509: and prt.run_method = 'C' );
1510:

Line 2469: from pay_run_types_f prt

2465: and organization_id = cp_business_group;
2466:
2467: cursor c_sepchk_run_type is
2468: select prt.run_type_id
2469: from pay_run_types_f prt
2470: where prt.shortname = 'SEP_PAY'
2471: and prt.legislation_code = 'CA';
2472:
2473: cursor c_assignment_run (cp_prepayment_action_id in number) is