APPS.PQH_EMPLOYEE_SALARY dependencies on PER_PAY_PROPOSALS

Line 27: L_Cur_Sal Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;

23: p_status OUT nocopy number,
24: p_pay_basis_frequency OUT nocopy varchar2
25: ) IS
26: --
27: L_Cur_Sal Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
28: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;
29: l_dummy_iv_id pay_input_values_f.Input_Value_id%TYPE;
30: l_business_group_id Per_All_Assignments_f.business_group_id%type;
31: --

Line 91: from per_pay_proposals

87: and pr.period_type = pt.period_type;
88: --
89: Cursor csr_proposal_rsn is
90: select proposal_reason
91: from per_pay_proposals
92: where assignment_id = p_assignment_id
93: and change_date = (Select max(change_date)
94: From per_pay_proposals
95: where assignment_id = p_assignment_id

Line 94: From per_pay_proposals

90: select proposal_reason
91: from per_pay_proposals
92: where assignment_id = p_assignment_id
93: and change_date = (Select max(change_date)
94: From per_pay_proposals
95: where assignment_id = p_assignment_id
96: and change_date <= p_Effective_Date);
97: --
98: Cursor csr_cur is

Line 589: from per_pay_proposals

585: Between pr.Effective_Start_date and pr.Effective_End_Date;
586: --
587: Cursor csr_proposal_rsn (p_change_dt in date) is
588: select proposal_reason
589: from per_pay_proposals
590: where assignment_id = p_assignment_id
591: and change_date = p_change_dt;
592: --
593: CURSOR C_Pay_Basis IS