APPS.PAY_CA_PAYROLL_ARCH dependencies on PAY_PRE_PAYMENTS

Line 130: to avoid to get pay_pre_payments of

126: c_mst_prepay_act%notfound.
127: 12-Mar-2003 vpandya 115.20 Changed proc create_child_actions
128: and create_chld_act_for_multi_gre:
129: added pay_org_payment_methods_f
130: to avoid to get pay_pre_payments of
131: 'Third Party Payments'
132: 02-Apr-2003 vpandya 115.21 2879620 Changed process_action:
133: Modified cursor c_time_period.
134: 11-Apr-2003 vpandya 115.22 Changed archive_data:

Line 799: ** all records from pay_pre_payments where source_action_id is

795: ** For Seperate Check we do the YTD balance calls with the Run
796: ** Action ID. So, we do not need to get the max. action which is
797: ** not seperate Check.
798: ** Also, p_ppp_source_action_id is set to null as we want to get
799: ** all records from pay_pre_payments where source_action_id is
800: ** is null.
801: ****************************************************************/
802: ln_ytd_balcall_aaid := p_payment_action_id;
803: if p_action_type in ('U', 'P') then

Line 1931: ,pay_pre_payments ppp

1927: select distinct
1928: paa.assignment_action_id
1929: ,paa.tax_unit_id
1930: from pay_assignment_actions paa
1931: ,pay_pre_payments ppp
1932: ,pay_org_payment_methods popm
1933: where paa.source_action_id = cp_master_prepay_act_id
1934: and ppp.assignment_action_id = paa.assignment_action_id
1935: and ppp.source_action_id is null

Line 1949: ,pay_pre_payments ppp

1945: select distinct
1946: paa.assignment_action_id
1947: ,paa.tax_unit_id
1948: from pay_assignment_actions paa
1949: ,pay_pre_payments ppp
1950: ,pay_org_payment_methods popm
1951: where paa.assignment_action_id = cp_master_prepay_act_id
1952: and ppp.assignment_action_id = paa.assignment_action_id
1953: and ppp.source_action_id is null

Line 2186: ,pay_pre_payments ppp

2182: paa.assignment_action_id,
2183: ppp.source_action_id
2184: from pay_payroll_actions ppa
2185: ,pay_assignment_actions paa
2186: ,pay_pre_payments ppp
2187: ,pay_org_payment_methods popm
2188: where ppa.consolidation_set_id
2189: = nvl(cp_cons_set_id,ppa.consolidation_set_id)
2190: and paa.action_status = 'C'

Line 2216: from pay_pre_payments ppp

2212: paa.assignment_id,
2213: paa.tax_unit_id,
2214: paa.assignment_action_id,
2215: ppp.source_action_id
2216: from pay_pre_payments ppp
2217: ,pay_assignment_actions paa
2218: ,pay_org_payment_methods popm
2219: where paa.assignment_action_id = cp_prepayment_action_id
2220: and ppp.assignment_action_id = paa.assignment_action_id