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_13 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:

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:
33: g_nic_smp_id pay_defined_balances.defined_balance_id%TYPE;

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:
33: g_nic_smp_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_sap_id pay_defined_balances.defined_balance_id%TYPE;

Line 33: g_nic_smp_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:
33: g_nic_smp_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_sap_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

Line 34: g_nic_sap_id pay_defined_balances.defined_balance_id%TYPE;

30: G_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
31:
32:
33: g_nic_smp_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_sap_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
38: G_NIC_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

Line 35: g_nic_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

31:
32:
33: g_nic_smp_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_sap_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
38: G_NIC_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
39:

Line 36: g_nic_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;

32:
33: g_nic_smp_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_sap_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
38: G_NIC_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
39:
40:

Line 37: g_nic_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;

33: g_nic_smp_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nic_sap_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
38: G_NIC_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
39:
40:
41: PROCEDURE get_globals

Line 38: G_NIC_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

34: g_nic_sap_id pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
36: g_nic_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nic_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
38: G_NIC_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
39:
40:
41: PROCEDURE get_globals
42: IS

Line 72: FROM pay_defined_balances db,

68: -- get the defined balance id for specified balance and dimension
69: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
70: IS
71: SELECT defined_balance_id
72: FROM pay_defined_balances db,
73: pay_balance_types b,
74: pay_balance_dimensions d
75: WHERE b.balance_name = p_balance_name
76: AND d.dimension_name = p_dimension_name