APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 77: FROM pay_balance_types pbt

73: CURSOR csr_defined_bal (c_balance_name IN Varchar2
74: ,c_dimension_name IN Varchar2
75: ,c_bg_id IN Number) IS
76: SELECT db.defined_balance_id
77: FROM pay_balance_types pbt
78: ,pay_defined_balances db
79: ,pay_balance_dimensions bd
80: WHERE pbt.balance_name = c_balance_name
81: AND pbt.balance_type_id = db.balance_type_id

Line 603: ,p_balance_name IN pay_balance_types.balance_name%TYPE

599: ,p_bg_id IN per_all_assignments_f.business_group_id%TYPE
600: ,p_payroll_id IN NUMBER
601: ,p_start_date IN DATE
602: ,p_end_date IN DATE
603: ,p_balance_name IN pay_balance_types.balance_name%TYPE
604: ,p_dim_name IN VARCHAR2) RETURN NUMBER IS
605:
606: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
607: l_balance_id pay_balance_types.balance_type_id%TYPE;

Line 607: l_balance_id pay_balance_types.balance_type_id%TYPE;

603: ,p_balance_name IN pay_balance_types.balance_name%TYPE
604: ,p_dim_name IN VARCHAR2) RETURN NUMBER IS
605:
606: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
607: l_balance_id pay_balance_types.balance_type_id%TYPE;
608: l_balance_amount NUMBER := 0;
609: l_dim_name VARCHAR2(100);
610:
611: --14839169