APPS.PAY_NZ_CEC_REPORT_PKG dependencies on PER_ASSIGNMENTS_F

Line 23: function PAY_NZ_GET_BAL_VALUE(p_assignment_id IN per_assignments_f.assignment_id%type,

19: -- Start Date and End Date Parameters for a defined balance id .
20: -- This function gets called from PAYNZCECETC.xml
21: --------------------------------------------------------------------
22:
23: function PAY_NZ_GET_BAL_VALUE(p_assignment_id IN per_assignments_f.assignment_id%type,
24: p_def_bal_id IN pay_defined_balances.defined_balance_id%type,
25: p_start_date IN date,
26: p_end_date IN date)
27: return number is

Line 29: Cursor csr_get_ass_act_id(p_assignment_id per_assignments_f.assignment_id%type,p_start_date date,p_end_date date) is

25: p_start_date IN date,
26: p_end_date IN date)
27: return number is
28:
29: Cursor csr_get_ass_act_id(p_assignment_id per_assignments_f.assignment_id%type,p_start_date date,p_end_date date) is
30: select paa.assignment_action_id
31: from pay_assignment_actions paa,
32: pay_payroll_actions ppa
33: where ppa.action_status ='C'