DBA Data[Home] [Help]

APPS.PAY_CA_PAYROLL_ARCH dependencies on PAY_ORG_PAYMENT_METHODS

Line 129: added pay_org_payment_methods_f

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.

Line 710: pay_org_payment_methods_f popm ,

706: pppm.payee_id,
707: pppm.payee_type
708: from pay_assignment_actions paa,
709: pay_pre_payments ppp,
710: pay_org_payment_methods_f popm ,
711: pay_personal_payment_methods_f pppm,
712: pay_payment_types ppt
713: where ppt.payment_type_id = popm.payment_type_id
714: and ppt.category = 'CH'

Line 2443: ,pay_org_payment_methods popm

2439: paa.assignment_action_id
2440: ,paa.tax_unit_id
2441: from pay_assignment_actions paa
2442: ,pay_pre_payments ppp
2443: ,pay_org_payment_methods popm
2444: where paa.source_action_id = cp_master_prepay_act_id
2445: and ppp.assignment_action_id = paa.assignment_action_id
2446: and ppp.source_action_id is null
2447: and nvl(ppp.value,0) <> 0

Line 2461: ,pay_org_payment_methods popm

2457: paa.assignment_action_id
2458: ,paa.tax_unit_id
2459: from pay_assignment_actions paa
2460: ,pay_pre_payments ppp
2461: ,pay_org_payment_methods popm
2462: where paa.assignment_action_id = cp_master_prepay_act_id
2463: and ppp.assignment_action_id = paa.assignment_action_id
2464: and ppp.source_action_id is null
2465: and nvl(ppp.value,0) <> 0

Line 2698: ,pay_org_payment_methods popm

2694: ppp.source_action_id
2695: from pay_payroll_actions ppa
2696: ,pay_assignment_actions paa
2697: ,pay_pre_payments ppp
2698: ,pay_org_payment_methods popm
2699: where ppa.consolidation_set_id
2700: = nvl(cp_cons_set_id,ppa.consolidation_set_id)
2701: and paa.action_status = 'C'
2702: and ppa.payroll_id = cp_payroll_id

Line 2729: ,pay_org_payment_methods popm

2725: paa.assignment_action_id,
2726: ppp.source_action_id
2727: from pay_pre_payments ppp
2728: ,pay_assignment_actions paa
2729: ,pay_org_payment_methods popm
2730: where paa.assignment_action_id = cp_prepayment_action_id
2731: and ppp.assignment_action_id = paa.assignment_action_id
2732: and nvl(ppp.value,0) <> 0
2733: and ppp.source_action_id is not null