APPS.PAY_CA_PAYROLL_ARCH dependencies on PAY_RUN_TYPES_F

Line 729: from pay_run_types_f prt,

725: (ppp.source_action_id is not null
726: and cp_ppp_source_action_id is null
727: and exists (
728: select ''
729: from pay_run_types_f prt,
730: pay_assignment_actions paa_run,
731: pay_payroll_actions ppa_run
732: where paa_run.assignment_action_id
733: = ppp.source_action_id

Line 1169: from pay_run_types_f prt

1165: and paa.assignment_id = cp_assignment_id
1166: and ppa.payroll_action_id = paa.payroll_action_id
1167: and nvl(paa.run_type_id,0) <> cp_sepchk_run_type
1168: and not exists ( select 1
1169: from pay_run_types_f prt
1170: where prt.legislation_code = 'CA'
1171: and prt.run_type_id = nvl(paa.run_type_id,0)
1172: and prt.run_method = 'C' )
1173: and ((paa.source_action_id is not null) OR

Line 1193: from pay_run_types_f prt

1189: and paa.tax_unit_id = cp_tax_unit_id
1190: and ppa.payroll_action_id = paa.payroll_action_id
1191: and nvl(paa.run_type_id,0) <> cp_sepchk_run_type
1192: and not exists ( select 1
1193: from pay_run_types_f prt
1194: where prt.legislation_code = 'CA'
1195: and prt.run_type_id = nvl(paa.run_type_id,0)
1196: and prt.run_method = 'C' )
1197: and paa.source_action_id is not null

Line 1673: from pay_run_types_f prt

1669: and paa.assignment_id = cp_assignment_id
1670: and paa.tax_unit_id = cp_tax_unit_id
1671: and nvl(paa.run_type_id,0) <> cp_sepchk_run_type
1672: and not exists ( select 1
1673: from pay_run_types_f prt
1674: where prt.legislation_code = 'CA'
1675: and prt.run_type_id = nvl(paa.run_type_id,0)
1676: and prt.run_method = 'C' );
1677:

Line 2010: from pay_run_types_f prt

2006: and paa.assignment_id = cp_assignment_id
2007: and paa.tax_unit_id = cp_tax_unit_id
2008: and nvl(paa.run_type_id,0) <> cp_sepchk_run_type
2009: and not exists ( select 1
2010: from pay_run_types_f prt
2011: where prt.legislation_code = 'CA'
2012: and prt.run_type_id = nvl(paa.run_type_id,0)
2013: and prt.run_method = 'C' );
2014:

Line 2980: from pay_run_types_f prt

2976: and organization_id = cp_business_group;
2977:
2978: cursor c_sepchk_run_type is
2979: select prt.run_type_id
2980: from pay_run_types_f prt
2981: where prt.shortname = 'SEP_PAY'
2982: and prt.legislation_code = 'CA';
2983:
2984: cursor c_assignment_run (cp_prepayment_action_id in number) is