APPS.PAY_MX_PAYROLL_ARCH dependencies on PAY_BALANCE_ATTRIBUTES

Line 536: pay_balance_attributes pba,

532: DECODE(pbad.attribute_name,
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,

Line 586: pay_balance_attributes pba,

582: DECODE(pbad.attribute_name,
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,

Line 993: pay_balance_attributes pba,

989: DECODE(pbad.attribute_name,
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,

Line 1370: pay_balance_attributes pba,

1366: DECODE(pbad.attribute_name,
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,

Line 1420: pay_balance_attributes pba,

1416: DECODE(pbad.attribute_name,
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,

Line 1472: pay_balance_attributes pba,

1468: DECODE(pbad.attribute_name,
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,

Line 1524: pay_balance_attributes pba,

1520: DECODE(pbad.attribute_name,
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,

Line 1875: pay_balance_attributes pba,

1871: DECODE(pbad.attribute_name,
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,

Line 1918: pay_balance_attributes pba,

1914: DECODE(pbad.attribute_name,
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,

Line 2618: pay_balance_attributes pba,

2614: SELECT NVL(pbtl.reporting_name, pbtl.balance_name) reporting_name,
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'

Line 4355: pay_balance_attributes pba,

4351: DECODE(pbad.attribute_name,
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,

Line 4398: pay_balance_attributes pba,

4394: DECODE(pbad.attribute_name,
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,