APPS.PQP_EXPREPLOD_PKG dependencies on PAY_DEFINED_BALANCES

Line 57: defined_balance_id pay_defined_balances.defined_balance_id%TYPE,

53: g_proc_name Varchar2(200) :='PQP_EXPREPLOD_PKG.';
54:
55: TYPE r_date_detail IS RECORD (
56: exception_report_id pqp_exception_reports.exception_report_id%TYPE,
57: defined_balance_id pay_defined_balances.defined_balance_id%TYPE,
58: payroll_id per_assignments_f.payroll_id%TYPE,
59: pay_date DATE
60: );
61: TYPE t_date_detail is Table OF r_date_detail

Line 74: defined_balance_id pay_defined_balances.defined_balance_id%TYPE

70: variance_value pqp_exception_reports.variance_value%TYPE,
71: variance_operator pqp_exception_reports.variance_operator%TYPE,
72: comparison_type pqp_exception_reports.comparison_type%TYPE,
73: comparison_value pqp_exception_reports.comparison_value%TYPE,
74: defined_balance_id pay_defined_balances.defined_balance_id%TYPE
75: );
76:
77: TYPE t_rep_detail IS TABLE OF r_rep_detail
78: INDEX BY binary_integer ;

Line 215: FROM pay_defined_balances

211: INSTR(DATABASE_ITEM_SUFFIX,'_COMP_'),
212: INSTR(DATABASE_ITEM_SUFFIX,'_TU_')
213: FROM pay_balance_dimensions where balance_dimension_id =
214: (SELECT balance_dimension_id
215: FROM pay_defined_balances
216: WHERE defined_balance_id =p_defined_balance_id
217: );
218: CURSOR c_grename IS
219: SELECT hou.name

Line 363: FROM pay_defined_balances

359: CURSOR c_get_bal_dim IS
360: SELECT INSTR(DATABASE_ITEM_SUFFIX,'_GRE_')
361: FROM pay_balance_dimensions where balance_dimension_id =
362: (SELECT balance_dimension_id
363: FROM pay_defined_balances
364: WHERE defined_balance_id =p_defined_balance_id
365: );
366:
367: CURSOR c_get_in_comp_name IS

Line 543: FROM pay_defined_balances

539: CURSOR c_def_bal (bal_type_id NUMBER,
540: dim_type_id NUMBER)
541: IS
542: SELECT defined_balance_id
543: FROM pay_defined_balances
544: WHERE balance_type_id=bal_type_id
545: AND balance_dimension_id=dim_type_id;
546: l_count NUMBER ;
547: l_count1 NUMBER ;