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 1010: pay_payment_types ppt,

1006: from pay_all_payrolls_f pp,
1007: pay_balance_dimensions pbd,
1008: pay_balance_types pbt,
1009: pay_defined_balances pdb,
1010: pay_payment_types ppt,
1011: pay_org_pay_method_usages_f pmu,
1012: pay_org_payment_methods_f opm,
1013: pay_payroll_actions ppa
1014: where ppa.payroll_action_id = payroll_action

Line 1521: from pay_payment_types ppt,

1517: opm.currency_code payment_currency,
1518: ppt.pre_validation_required validation_required,
1519: ppt.validation_value validation_value,
1520: opm.external_account_id external_account_id
1521: from pay_payment_types ppt,
1522: pay_org_payment_methods_f opm,
1523: pay_run_type_org_methods_f rtom,
1524: pay_org_pay_method_usages_f opmu,
1525: pay_payroll_actions ppa,

Line 1562: pay_payment_types ppt,

1558: ppt.pre_validation_required validation_required,
1559: ppt.validation_value validation_value,
1560: opm.external_account_id external_account_id
1561: from pay_external_accounts pea,
1562: pay_payment_types ppt,
1563: pay_org_payment_methods_f opm,
1564: pay_personal_payment_methods_f ppm,
1565: pay_assignment_actions act
1566: where act.assignment_action_id=p_assignment_action

Line 2473: pay_payment_types ppt,

2469: pay_element_entries_f pee,
2470: pay_personal_payment_methods_f ppm,
2471: pay_external_accounts pea,
2472: pay_org_payment_methods_f opm,
2473: pay_payment_types ppt,
2474: pay_assignment_actions paa,
2475: pay_payroll_actions ppa
2476: where prr.run_result_id = p_run_results
2477: /* Bug 12364433*/

Line 2733: pay_payment_types ppt,

2729: ppa.effective_date,
2730: ppa.business_group_id)) payment_date
2731: from
2732: pay_external_accounts pea,
2733: pay_payment_types ppt,
2734: pay_org_payment_methods_f popm,
2735: pay_org_payment_methods_f popm_par,
2736: pay_org_pay_method_usages_f popmu,
2737: pay_assignment_actions paa,