APPS.PQP_EXPREPLOD_PKG dependencies on PAY_DEFINED_BALANCES

Line 56: defined_balance_id pay_defined_balances.defined_balance_id%TYPE,

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

Line 73: defined_balance_id pay_defined_balances.defined_balance_id%TYPE

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

Line 212: FROM pay_defined_balances

208: SELECT INSTR(DATABASE_ITEM_SUFFIX,'_GRE_'),
209: INSTR(DATABASE_ITEM_SUFFIX,'_LE_')
210: FROM pay_balance_dimensions where balance_dimension_id =
211: (SELECT balance_dimension_id
212: FROM pay_defined_balances
213: WHERE defined_balance_id =p_defined_balance_id
214: );
215: CURSOR c_grename IS
216: SELECT hou.name

Line 386: FROM pay_defined_balances

382: CURSOR c_def_bal (bal_type_id NUMBER,
383: dim_type_id NUMBER)
384: IS
385: SELECT defined_balance_id
386: FROM pay_defined_balances
387: WHERE balance_type_id=bal_type_id
388: AND balance_dimension_id=dim_type_id;
389: l_count NUMBER ;
390: l_count1 NUMBER ;