[Home] [Help]
125: condition exit from the loop if
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.
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
1936: and nvl(ppp.value,0) <> 0
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
1954: and nvl(ppp.value,0) <> 0
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'
2191: and ppa.payroll_id = cp_payroll_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
2221: and nvl(ppp.value,0) <> 0
2222: and ppp.source_action_id is not null