eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_MX_PAYROLL_ARCH dependencies on PAY_BALANCE_TYPES

Line 542: pay_balance_types pbt_pri,

538: pay_run_balances prb,
539: pay_action_interlocks pai,
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

Line 543: pay_balance_types pbt_sec,

539: pay_action_interlocks pai,
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

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 593: pay_balance_types pbt_pri,

589: pay_input_values_f piv,
590: pay_action_interlocks pai,
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

Line 594: pay_balance_types pbt_sec,

590: pay_action_interlocks pai,
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

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 962: FROM pay_balance_types

958:
959: CURSOR c_get_balance (cp_balance_name IN VARCHAR2
960: ,cp_legislation_code IN VARCHAR2) IS
961: SELECT balance_type_id
962: FROM pay_balance_types
963: WHERE legislation_code = cp_legislation_code
964: AND balance_name = cp_balance_name;
965:
966: CURSOR c_last_per_xfr_run IS

Line 995: pay_balance_types pbt_pri,

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
999: WHERE pbad.attribute_name IN ('Employee Earnings',

Line 996: pay_balance_types pbt_sec,

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
999: WHERE pbad.attribute_name IN ('Employee Earnings',
1000: 'Hourly Earnings',

Line 1372: pay_balance_types pbt_pri,

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,
1376: pay_assignment_actions paa,

Line 1373: pay_balance_types pbt_sec,

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,
1376: pay_assignment_actions paa,
1377: pay_payroll_actions ppa

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 1422: pay_balance_types pbt_pri,

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,
1426: pay_input_values_f piv,

Line 1423: pay_balance_types pbt_sec,

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,
1426: pay_input_values_f piv,
1427: pay_assignment_actions paa,

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 1474: pay_balance_types pbt_pri,

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,
1478: pay_assignment_actions paa,

Line 1475: pay_balance_types pbt_sec,

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,
1478: pay_assignment_actions paa,
1479: pay_action_interlocks pai,

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 1526: pay_balance_types pbt_pri,

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,
1530: pay_input_values_f piv,

Line 1527: pay_balance_types pbt_sec,

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,
1530: pay_input_values_f piv,
1531: pay_assignment_actions paa,

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 1877: pay_balance_types pbt_pri,

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
1881: WHERE pbad.attribute_name IN ('Employee Earnings',

Line 1878: pay_balance_types pbt_sec,

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
1881: WHERE pbad.attribute_name IN ('Employee Earnings',
1882: 'Hourly Earnings',

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 1920: pay_balance_types pbt_pri,

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,
1924: pay_payroll_actions ppa,

Line 1921: pay_balance_types pbt_sec,

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,
1924: pay_payroll_actions ppa,
1925: pay_run_results prr,

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 2633: FROM pay_balance_types

2629: UNION
2630: SELECT balance_name reporting_name,
2631: balance_type_id,
2632: 'SUMMARY'
2633: FROM pay_balance_types
2634: WHERE balance_name IN ('Gross Earnings',
2635: 'Tax Deductions',
2636: 'Deductions',
2637: 'Net Pay')

Line 2651: FROM pay_balance_types

2647:
2648: CURSOR cur_bal_type IS
2649: SELECT balance_name,
2650: balance_type_id
2651: FROM pay_balance_types
2652: WHERE legislation_code = 'MX'
2653: AND balance_name = 'Gross Earnings';
2654: --IN ( 'Gross Earnings', 'Total Pay' );
2655:

Line 4357: pay_balance_types pbt_pri,

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
4361: WHERE pbad.attribute_name IN ('Employee Earnings',

Line 4358: pay_balance_types pbt_sec,

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
4361: WHERE pbad.attribute_name IN ('Employee Earnings',
4362: 'Hourly Earnings',

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 4400: pay_balance_types pbt_pri,

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,
4404: pay_payroll_actions ppa,

Line 4401: pay_balance_types pbt_sec,

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,
4404: pay_payroll_actions ppa,
4405: pay_run_results prr,

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