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_JP_UITE_ARCH_PKG dependencies on PAY_BALANCE_TYPES

Line 999: CURSOR lcu_get_bal_id(p_balance_name pay_balance_types.balance_name%TYPE

995: AND NVL(p_last_std_process_date,PTP.start_date)
996: AND PTP.start_date <= p_termination_date
997: ORDER BY PTP.start_date DESC;
998: --
999: CURSOR lcu_get_bal_id(p_balance_name pay_balance_types.balance_name%TYPE
1000: ,p_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE)
1001: IS
1002: SELECT PDB.defined_balance_id
1003: ,PBT.balance_type_id

Line 1004: FROM pay_balance_types PBT

1000: ,p_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE)
1001: IS
1002: SELECT PDB.defined_balance_id
1003: ,PBT.balance_type_id
1004: FROM pay_balance_types PBT
1005: ,pay_balance_dimensions PBD
1006: ,pay_defined_balances PDB
1007: WHERE PBT.balance_name = p_balance_name
1008: AND PBD.database_item_suffix = p_database_item_suffix

Line 1013: ,p_balance_type_id pay_balance_types.balance_type_id%TYPE)

1009: AND PBT.balance_type_id = PDB.balance_type_id
1010: AND PBD.balance_dimension_id = PDB.balance_dimension_id;
1011: --
1012: CURSOR lcu_balance_asg_run(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
1013: ,p_balance_type_id pay_balance_types.balance_type_id%TYPE)
1014: IS
1015: SELECT 'Y'
1016: FROM pay_assignment_actions ASSACT,
1017: pay_payroll_actions PACT,

Line 1031: CURSOR lcu_balance_asg_prev_run(p_balance_type_id pay_balance_types.balance_type_id%TYPE

1027: AND FEED.input_value_id = TARGET.input_value_id
1028: AND FEED.balance_type_id = p_balance_type_id
1029: AND PACT.effective_date BETWEEN FEED.effective_start_date AND FEED.effective_end_date;
1030: --
1031: CURSOR lcu_balance_asg_prev_run(p_balance_type_id pay_balance_types.balance_type_id%TYPE
1032: ,p_date_earned pay_payroll_actions.date_earned%TYPE
1033: )
1034: IS
1035: SELECT ASSACT.assignment_action_id

Line 1089: ln_bpd_baltyp_id pay_balance_types.balance_type_id%TYPE;

1085: ln_sal_a_bal_id pay_defined_balances.defined_balance_id%TYPE;
1086: ln_sal_b_bal_id pay_defined_balances.defined_balance_id%TYPE;
1087: ln_sal_a_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1088: ln_sal_b_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1089: ln_bpd_baltyp_id pay_balance_types.balance_type_id%TYPE;
1090: ln_sal_a_baltyp_id pay_balance_types.balance_type_id%TYPE;
1091: ln_sal_b_baltyp_id pay_balance_types.balance_type_id%TYPE;
1092: ln_sal_a_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1093: ln_sal_b_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;

Line 1090: ln_sal_a_baltyp_id pay_balance_types.balance_type_id%TYPE;

1086: ln_sal_b_bal_id pay_defined_balances.defined_balance_id%TYPE;
1087: ln_sal_a_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1088: ln_sal_b_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1089: ln_bpd_baltyp_id pay_balance_types.balance_type_id%TYPE;
1090: ln_sal_a_baltyp_id pay_balance_types.balance_type_id%TYPE;
1091: ln_sal_b_baltyp_id pay_balance_types.balance_type_id%TYPE;
1092: ln_sal_a_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1093: ln_sal_b_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1094: ln_wage_dis_count NUMBER:=0; -- Count excluding payment days less than 11 Days

Line 1091: ln_sal_b_baltyp_id pay_balance_types.balance_type_id%TYPE;

1087: ln_sal_a_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1088: ln_sal_b_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1089: ln_bpd_baltyp_id pay_balance_types.balance_type_id%TYPE;
1090: ln_sal_a_baltyp_id pay_balance_types.balance_type_id%TYPE;
1091: ln_sal_b_baltyp_id pay_balance_types.balance_type_id%TYPE;
1092: ln_sal_a_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1093: ln_sal_b_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1094: ln_wage_dis_count NUMBER:=0; -- Count excluding payment days less than 11 Days
1095: ln_line_count NUMBER;

Line 1092: ln_sal_a_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;

1088: ln_sal_b_prev_bal_id pay_defined_balances.defined_balance_id%TYPE;
1089: ln_bpd_baltyp_id pay_balance_types.balance_type_id%TYPE;
1090: ln_sal_a_baltyp_id pay_balance_types.balance_type_id%TYPE;
1091: ln_sal_b_baltyp_id pay_balance_types.balance_type_id%TYPE;
1092: ln_sal_a_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1093: ln_sal_b_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1094: ln_wage_dis_count NUMBER:=0; -- Count excluding payment days less than 11 Days
1095: ln_line_count NUMBER;
1096: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 1093: ln_sal_b_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;

1089: ln_bpd_baltyp_id pay_balance_types.balance_type_id%TYPE;
1090: ln_sal_a_baltyp_id pay_balance_types.balance_type_id%TYPE;
1091: ln_sal_b_baltyp_id pay_balance_types.balance_type_id%TYPE;
1092: ln_sal_a_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1093: ln_sal_b_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1094: ln_wage_dis_count NUMBER:=0; -- Count excluding payment days less than 11 Days
1095: ln_line_count NUMBER;
1096: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1097: ln_prev_ass_a_act_id pay_assignment_actions.assignment_action_id%TYPE;

Line 1799: CURSOR lcu_get_bal_id(p_balance_name pay_balance_types.balance_name%TYPE

1795: AND ppa2.payroll_action_id = paa2.payroll_action_id
1796: AND ppa2.action_type = 'V')
1797: ORDER BY paa.action_sequence;
1798: --
1799: CURSOR lcu_get_bal_id(p_balance_name pay_balance_types.balance_name%TYPE
1800: ,p_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE)
1801: IS
1802: SELECT PDB.defined_balance_id
1803: FROM pay_balance_types PBT

Line 1803: FROM pay_balance_types PBT

1799: CURSOR lcu_get_bal_id(p_balance_name pay_balance_types.balance_name%TYPE
1800: ,p_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE)
1801: IS
1802: SELECT PDB.defined_balance_id
1803: FROM pay_balance_types PBT
1804: ,pay_balance_dimensions PBD
1805: ,pay_defined_balances PDB
1806: WHERE PBT.balance_name = p_balance_name
1807: AND PBD.database_item_suffix = p_database_item_suffix