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.CREATE_GB_RTI_EPS_RECORD dependencies on PAY_DEFINED_BALANCES

Line 24: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;

20: G_user_ID NUMBER;
21: GLOBAL_MISSING EXCEPTION;
22: MANDATORY_VALUES_MISSING EXCEPTION;
23: EPS_ALREADY_PRESENT EXCEPTION;
24: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
25: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
26: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
27: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
28: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;

Line 25: g_smp_id pay_defined_balances.defined_balance_id%TYPE;

21: GLOBAL_MISSING EXCEPTION;
22: MANDATORY_VALUES_MISSING EXCEPTION;
23: EPS_ALREADY_PRESENT EXCEPTION;
24: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
25: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
26: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
27: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
28: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
29: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

Line 26: g_sap_id pay_defined_balances.defined_balance_id%TYPE;

22: MANDATORY_VALUES_MISSING EXCEPTION;
23: EPS_ALREADY_PRESENT EXCEPTION;
24: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
25: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
26: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
27: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
28: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
29: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
30: G_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

Line 27: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

23: EPS_ALREADY_PRESENT EXCEPTION;
24: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
25: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
26: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
27: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
28: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
29: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
30: G_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
31:

Line 28: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;

24: g_ssp_id pay_defined_balances.defined_balance_id%TYPE;
25: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
26: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
27: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
28: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
29: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
30: G_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
31:
32: PROCEDURE get_globals

Line 29: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

25: g_smp_id pay_defined_balances.defined_balance_id%TYPE;
26: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
27: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
28: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
29: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
30: G_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
31:
32: PROCEDURE get_globals
33: IS

Line 30: G_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

26: g_sap_id pay_defined_balances.defined_balance_id%TYPE;
27: g_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
28: g_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
29: g_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
30: G_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
31:
32: PROCEDURE get_globals
33: IS
34: --This is to fetch details from Organisation Details.

Line 63: FROM pay_defined_balances db,

59: -- get the defined balance id for specified balance and dimension
60: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
61: IS
62: SELECT defined_balance_id
63: FROM pay_defined_balances db,
64: pay_balance_types b,
65: pay_balance_dimensions d
66: WHERE b.balance_name = p_balance_name
67: AND d.dimension_name = p_dimension_name

Line 426: l_smp_id pay_defined_balances.defined_balance_id%TYPE;

422: p_amount in number,
423: p_rec_amount out nocopy number,
424: p_nic_amount out nocopy number
425: ) return number is
426: l_smp_id pay_defined_balances.defined_balance_id%TYPE;
427: l_sap_id pay_defined_balances.defined_balance_id%TYPE;
428: l_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
429: l_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
430: l_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

Line 427: l_sap_id pay_defined_balances.defined_balance_id%TYPE;

423: p_rec_amount out nocopy number,
424: p_nic_amount out nocopy number
425: ) return number is
426: l_smp_id pay_defined_balances.defined_balance_id%TYPE;
427: l_sap_id pay_defined_balances.defined_balance_id%TYPE;
428: l_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
429: l_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
430: l_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
431: L_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

Line 428: l_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

424: p_nic_amount out nocopy number
425: ) return number is
426: l_smp_id pay_defined_balances.defined_balance_id%TYPE;
427: l_sap_id pay_defined_balances.defined_balance_id%TYPE;
428: l_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
429: l_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
430: l_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
431: L_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
432: l_element_name pay_element_types_f.element_name%TYPE;

Line 429: l_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;

425: ) return number is
426: l_smp_id pay_defined_balances.defined_balance_id%TYPE;
427: l_sap_id pay_defined_balances.defined_balance_id%TYPE;
428: l_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
429: l_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
430: l_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
431: L_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
432: l_element_name pay_element_types_f.element_name%TYPE;
433: l_eff_date date;

Line 430: l_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

426: l_smp_id pay_defined_balances.defined_balance_id%TYPE;
427: l_sap_id pay_defined_balances.defined_balance_id%TYPE;
428: l_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
429: l_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
430: l_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
431: L_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
432: l_element_name pay_element_types_f.element_name%TYPE;
433: l_eff_date date;
434: l_rec_rate number;

Line 431: L_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

427: l_sap_id pay_defined_balances.defined_balance_id%TYPE;
428: l_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
429: l_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
430: l_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
431: L_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
432: l_element_name pay_element_types_f.element_name%TYPE;
433: l_eff_date date;
434: l_rec_rate number;
435: l_nic_rate number;

Line 440: FROM pay_defined_balances db,

436: l_payroll_id number;
437: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
438: IS
439: SELECT defined_balance_id
440: FROM pay_defined_balances db,
441: pay_balance_types b,
442: pay_balance_dimensions d
443: WHERE b.balance_name = p_balance_name
444: AND d.dimension_name = p_dimension_name