APPS.HR_PAY_RATE_GSP_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 6: (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,

2: /* $Header: hrpaygsp.pkb 120.5.12010000.2 2009/06/12 07:59:16 gpurohit ship $ */
3:
4: -- get the updated salary because of Grade Ladder assignment
5: procedure get_employee_salary
6: (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
7: P_Effective_Date In Date,
8: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ
9: ) IS
10:

Line 79: (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,

75: end get_employee_salary;
76:
77: -- get the current salary , called before updating the assignment
78: procedure get_employee_current_salary
79: (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
80: P_Effective_Date In Date,
81: p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ
82: ) IS
83:

Line 573: P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,

569: (
570: p_item_type IN wf_items.item_type%type,
571: p_item_key IN wf_items.item_key%TYPE,
572: p_ltt_salary_data IN sshr_sal_prop_tab_typ,
573: P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
574: P_Effective_Date In Date,
575: p_transaction_id in number,
576: p_transaction_step_id in number,
577: p_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,

Line 577: p_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,

573: P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
574: P_Effective_Date In Date,
575: p_transaction_id in number,
576: p_transaction_step_id in number,
577: p_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
578: p_old_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
579: p_business_group_id in Per_All_Assignments_F.business_group_id%TYPE
580: )
581: is

Line 578: p_old_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,

574: P_Effective_Date In Date,
575: p_transaction_id in number,
576: p_transaction_step_id in number,
577: p_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
578: p_old_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
579: p_business_group_id in Per_All_Assignments_F.business_group_id%TYPE
580: )
581: is
582:

Line 579: p_business_group_id in Per_All_Assignments_F.business_group_id%TYPE

575: p_transaction_id in number,
576: p_transaction_step_id in number,
577: p_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
578: p_old_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
579: p_business_group_id in Per_All_Assignments_F.business_group_id%TYPE
580: )
581: is
582:
583: cursor pay_txn is

Line 592: l_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;

588: select pay_proposal_id from per_pay_proposals where assignment_id=p_assignment_id and
589: P_Effective_Date between change_date and date_to;
590:
591: message VARCHAR2(10000) := '';
592: l_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;
593: l_old_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;
594: pay_txn_id per_pay_transactions.pay_transaction_id%type;
595: pay_prop_id per_pay_proposals.pay_proposal_id%type;
596:

Line 593: l_old_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;

589: P_Effective_Date between change_date and date_to;
590:
591: message VARCHAR2(10000) := '';
592: l_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;
593: l_old_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;
594: pay_txn_id per_pay_transactions.pay_transaction_id%type;
595: pay_prop_id per_pay_proposals.pay_proposal_id%type;
596:
597: begin