APPS.HR_PRE_PAY dependencies on PAY_PAYMENT_TYPES

Line 39: category pay_payment_types.category%type,

35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,
39: category pay_payment_types.category%type,
40: cash_rule varchar2(40),
41: payment_currency varchar2(16),
42: base_currency varchar2(16)
43: );

Line 87: pay_payment_types ppt,

83: ppt.validation_value validation_value,
84: opm.external_account_id external_account_id
85: -- from hr_lookups hlu,
86: from pay_external_accounts pea,
87: pay_payment_types ppt,
88: pay_org_payment_methods_f opm,
89: pay_personal_payment_methods_f ppm
90: where ppm.assignment_id = p_assignment
91: and ppm.run_type_id is null

Line 898: pay_payment_types ppt,

894: pay_bg_id
895: from pay_balance_dimensions pbd,
896: pay_balance_types pbt,
897: pay_defined_balances pdb,
898: pay_payment_types ppt,
899: pay_all_payrolls_f pp,
900: pay_org_payment_methods_f opm,
901: pay_payroll_actions ppa
902: where ppa.payroll_action_id = payroll_action

Line 1005: pay_payment_types ppt,

1001: from pay_all_payrolls_f pp,
1002: pay_balance_dimensions pbd,
1003: pay_balance_types pbt,
1004: pay_defined_balances pdb,
1005: pay_payment_types ppt,
1006: pay_org_pay_method_usages_f pmu,
1007: pay_org_payment_methods_f opm,
1008: pay_payroll_actions ppa
1009: where ppa.payroll_action_id = payroll_action

Line 1516: from pay_payment_types ppt,

1512: opm.currency_code payment_currency,
1513: ppt.pre_validation_required validation_required,
1514: ppt.validation_value validation_value,
1515: opm.external_account_id external_account_id
1516: from pay_payment_types ppt,
1517: pay_org_payment_methods_f opm,
1518: pay_run_type_org_methods_f rtom,
1519: pay_org_pay_method_usages_f opmu,
1520: pay_payroll_actions ppa,

Line 1557: pay_payment_types ppt,

1553: ppt.pre_validation_required validation_required,
1554: ppt.validation_value validation_value,
1555: opm.external_account_id external_account_id
1556: from pay_external_accounts pea,
1557: pay_payment_types ppt,
1558: pay_org_payment_methods_f opm,
1559: pay_personal_payment_methods_f ppm,
1560: pay_assignment_actions act
1561: where act.assignment_action_id=p_assignment_action

Line 2448: pay_payment_types ppt,

2444: pay_element_entries_f pee,
2445: pay_personal_payment_methods_f ppm,
2446: pay_external_accounts pea,
2447: pay_org_payment_methods_f opm,
2448: pay_payment_types ppt,
2449: pay_assignment_actions paa,
2450: pay_payroll_actions ppa
2451: where prr.run_result_id = p_run_results
2452: and prr.source_id = pee.element_entry_id

Line 2697: pay_payment_types ppt,

2693: ppa.effective_date,
2694: ppa.business_group_id)) payment_date
2695: from
2696: pay_external_accounts pea,
2697: pay_payment_types ppt,
2698: pay_org_payment_methods_f popm,
2699: pay_org_payment_methods_f popm_par,
2700: pay_org_pay_method_usages_f popmu,
2701: pay_assignment_actions paa,