DBA Data[Home] [Help]

APPS.PAY_MX_PAYROLL_ARCH dependencies on PAY_DEFINED_BALANCES

Line 537: pay_defined_balances pdb,

533: 'Employee Earnings', pbt_sec.balance_type_id,
534: NULL) -- Days Balance
535: FROM pay_bal_attribute_definitions pbad,
536: pay_balance_attributes pba,
537: pay_defined_balances pdb,
538: pay_run_balances prb,
539: pay_action_interlocks pai,
540: pay_assignment_actions paa_pre,
541: pay_payroll_actions ppa_pre,

Line 587: pay_defined_balances pdb,

583: 'Employee Earnings', pbt_sec.balance_type_id,
584: NULL) -- Days Balance
585: FROM pay_bal_attribute_definitions pbad,
586: pay_balance_attributes pba,
587: pay_defined_balances pdb,
588: pay_run_results prr,
589: pay_input_values_f piv,
590: pay_action_interlocks pai,
591: pay_assignment_actions paa_pre,

Line 994: pay_defined_balances pdb,

990: 'Employee Earnings', pbt_sec.balance_type_id,
991: NULL) -- Days Balance
992: FROM pay_bal_attribute_definitions pbad,
993: pay_balance_attributes pba,
994: pay_defined_balances pdb,
995: pay_balance_types pbt_pri,
996: pay_balance_types pbt_sec,
997: pay_input_values_f piv,
998: pay_element_types_f pet

Line 1371: pay_defined_balances pdb,

1367: 'Employee Earnings', pbt_sec.balance_type_id,
1368: NULL) -- Days Balance
1369: FROM pay_bal_attribute_definitions pbad,
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,

Line 1421: pay_defined_balances pdb,

1417: 'Employee Earnings', pbt_sec.balance_type_id,
1418: NULL) -- Days Balance
1419: FROM pay_bal_attribute_definitions pbad,
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,

Line 1473: pay_defined_balances pdb,

1469: 'Employee Earnings', pbt_sec.balance_type_id,
1470: NULL) -- Days Balance
1471: FROM pay_bal_attribute_definitions pbad,
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,

Line 1525: pay_defined_balances pdb,

1521: 'Employee Earnings', pbt_sec.balance_type_id,
1522: NULL) -- Days Balance
1523: FROM pay_bal_attribute_definitions pbad,
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,

Line 1876: pay_defined_balances pdb,

1872: 'Employee Earnings', pbt_sec.balance_type_id,
1873: NULL) -- Days Balance
1874: FROM pay_bal_attribute_definitions pbad,
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

Line 1919: pay_defined_balances pdb,

1915: 'Employee Earnings', pbt_sec.balance_type_id,
1916: NULL) -- Days Balance
1917: FROM pay_bal_attribute_definitions pbad,
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,

Line 2619: pay_defined_balances pdb,

2615: pbtl.balance_type_id,
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: )

Line 4356: pay_defined_balances pdb,

4352: 'Employee Earnings', pbt_sec.balance_type_id,
4353: NULL) -- Days Balance
4354: FROM pay_bal_attribute_definitions pbad,
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

Line 4399: pay_defined_balances pdb,

4395: 'Employee Earnings', pbt_sec.balance_type_id,
4396: NULL) -- Days Balance
4397: FROM pay_bal_attribute_definitions pbad,
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,