DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 35: ,database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE

31: TYPE Rec_Changes IS TABLE OF t_interpretor_output_tab_rec INDEX BY BINARY_INTEGER;
32: --
33: TYPE Balance_Rec IS RECORD (defined_balance_id pay_defined_balances.defined_balance_id%TYPE
34: ,balance_name pay_balance_types.balance_name%TYPE
35: ,database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE
36: ,context VARCHAR2(20)
37: ,context_val VARCHAR2(20));
38: TYPE Bal_Table IS TABLE OF Balance_Rec INDEX BY BINARY_INTEGER;
39: g_nom_bal_def_table Bal_Table;

Line 42: ,database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE);

38: TYPE Bal_Table IS TABLE OF Balance_Rec INDEX BY BINARY_INTEGER;
39: g_nom_bal_def_table Bal_Table;
40: --
41: TYPE Balance_Val IS RECORD ( balance_value NUMBER
42: ,database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE);
43: TYPE Bal_Value IS TABLE OF Balance_Val INDEX BY BINARY_INTEGER;
44: --
45: TYPE Retro_table IS RECORD (start_date DATE
46: ,end_date DATE

Line 53: ,database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE

49: --
50: TYPE Balance_col_Rec IS RECORD (defined_balance_id pay_defined_balances.defined_balance_id%TYPE
51: ,defined_balance_id2 pay_defined_balances.defined_balance_id%TYPE
52: ,balance_name pay_balance_types.balance_name%TYPE
53: ,database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE
54: ,database_item_suffix2 pay_balance_dimensions.database_item_suffix%TYPE
55: ,context VARCHAR2(100)
56: ,context_val VARCHAR2(100)
57: ,balance_value NUMBER

Line 54: ,database_item_suffix2 pay_balance_dimensions.database_item_suffix%TYPE

50: TYPE Balance_col_Rec IS RECORD (defined_balance_id pay_defined_balances.defined_balance_id%TYPE
51: ,defined_balance_id2 pay_defined_balances.defined_balance_id%TYPE
52: ,balance_name pay_balance_types.balance_name%TYPE
53: ,database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE
54: ,database_item_suffix2 pay_balance_dimensions.database_item_suffix%TYPE
55: ,context VARCHAR2(100)
56: ,context_val VARCHAR2(100)
57: ,balance_value NUMBER
58: ,balance_value2 NUMBER);