APPS.PAY_MX_PAYROLL_ARCH dependencies on PAY_BALANCE_TYPES_TL

Line 544: pay_balance_types_tl pbtl

540: pay_assignment_actions paa_pre,
541: pay_payroll_actions ppa_pre,
542: pay_balance_types pbt_pri,
543: pay_balance_types pbt_sec,
544: pay_balance_types_tl pbtl
545: WHERE ppa_pre.action_type IN ('U', 'P')
546: AND ppa_pre.effective_date > cp_last_xfr_eff_date
547: AND ppa_pre.effective_date <= cp_last_pymt_eff_date
548: AND paa_pre.payroll_action_id = ppa_pre.payroll_action_id

Line 595: pay_balance_types_tl pbtl

591: pay_assignment_actions paa_pre,
592: pay_payroll_actions ppa_pre,
593: pay_balance_types pbt_pri,
594: pay_balance_types pbt_sec,
595: pay_balance_types_tl pbtl
596: WHERE ppa_pre.action_type IN ('U', 'P')
597: AND ppa_pre.effective_date > cp_last_xfr_eff_date
598: AND ppa_pre.effective_date <= cp_last_pymt_eff_date
599: AND paa_pre.payroll_action_id = ppa_pre.payroll_action_id

Line 1374: pay_balance_types_tl pbtl,

1370: pay_balance_attributes pba,
1371: pay_defined_balances pdb,
1372: pay_balance_types pbt_pri,
1373: pay_balance_types pbt_sec,
1374: pay_balance_types_tl pbtl,
1375: pay_run_balances prb,
1376: pay_assignment_actions paa,
1377: pay_payroll_actions ppa
1378: WHERE pbad.attribute_name IN ('Employee Earnings',

Line 1424: pay_balance_types_tl pbtl,

1420: pay_balance_attributes pba,
1421: pay_defined_balances pdb,
1422: pay_balance_types pbt_pri,
1423: pay_balance_types pbt_sec,
1424: pay_balance_types_tl pbtl,
1425: pay_run_results prr,
1426: pay_input_values_f piv,
1427: pay_assignment_actions paa,
1428: pay_payroll_actions ppa

Line 1476: pay_balance_types_tl pbtl,

1472: pay_balance_attributes pba,
1473: pay_defined_balances pdb,
1474: pay_balance_types pbt_pri,
1475: pay_balance_types pbt_sec,
1476: pay_balance_types_tl pbtl,
1477: pay_run_balances prb,
1478: pay_assignment_actions paa,
1479: pay_action_interlocks pai,
1480: pay_payroll_actions ppa

Line 1528: pay_balance_types_tl pbtl,

1524: pay_balance_attributes pba,
1525: pay_defined_balances pdb,
1526: pay_balance_types pbt_pri,
1527: pay_balance_types pbt_sec,
1528: pay_balance_types_tl pbtl,
1529: pay_run_results prr,
1530: pay_input_values_f piv,
1531: pay_assignment_actions paa,
1532: pay_action_interlocks pai,

Line 1879: pay_balance_types_tl pbtl,

1875: pay_balance_attributes pba,
1876: pay_defined_balances pdb,
1877: pay_balance_types pbt_pri,
1878: pay_balance_types pbt_sec,
1879: pay_balance_types_tl pbtl,
1880: pay_run_balances prb
1881: WHERE pbad.attribute_name IN ('Employee Earnings',
1882: 'Hourly Earnings',
1883: 'Deductions',

Line 1922: pay_balance_types_tl pbtl,

1918: pay_balance_attributes pba,
1919: pay_defined_balances pdb,
1920: pay_balance_types pbt_pri,
1921: pay_balance_types pbt_sec,
1922: pay_balance_types_tl pbtl,
1923: pay_assignment_actions paa,
1924: pay_payroll_actions ppa,
1925: pay_run_results prr,
1926: pay_input_values_f piv

Line 2620: pay_balance_types_tl pbtl

2616: pbad.attribute_name
2617: FROM pay_bal_attribute_definitions pbad,
2618: pay_balance_attributes pba,
2619: pay_defined_balances pdb,
2620: pay_balance_types_tl pbtl
2621: WHERE pbad.attribute_name IN ('Employee Taxes',
2622: 'Tax Calculation Details'
2623: )
2624: AND pbad.legislation_code = 'MX'

Line 4359: pay_balance_types_tl pbtl,

4355: pay_balance_attributes pba,
4356: pay_defined_balances pdb,
4357: pay_balance_types pbt_pri,
4358: pay_balance_types pbt_sec,
4359: pay_balance_types_tl pbtl,
4360: pay_run_balances prb
4361: WHERE pbad.attribute_name IN ('Employee Earnings',
4362: 'Hourly Earnings',
4363: 'Deductions',

Line 4402: pay_balance_types_tl pbtl,

4398: pay_balance_attributes pba,
4399: pay_defined_balances pdb,
4400: pay_balance_types pbt_pri,
4401: pay_balance_types pbt_sec,
4402: pay_balance_types_tl pbtl,
4403: pay_assignment_actions paa,
4404: pay_payroll_actions ppa,
4405: pay_run_results prr,
4406: pay_input_values_f piv