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 2008/06/11 14:05:40 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 569: P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,

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

Line 573: p_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,

569: P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
570: P_Effective_Date In Date,
571: p_transaction_id in number,
572: p_transaction_step_id in number,
573: p_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
574: p_old_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
575: p_business_group_id in Per_All_Assignments_F.business_group_id%TYPE
576: )
577: is

Line 574: p_old_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,

570: P_Effective_Date In Date,
571: p_transaction_id in number,
572: p_transaction_step_id in number,
573: p_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
574: p_old_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
575: p_business_group_id in Per_All_Assignments_F.business_group_id%TYPE
576: )
577: is
578:

Line 575: p_business_group_id in Per_All_Assignments_F.business_group_id%TYPE

571: p_transaction_id in number,
572: p_transaction_step_id in number,
573: p_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
574: p_old_pay_basis_id in Per_All_Assignments_F.pay_basis_id%TYPE,
575: p_business_group_id in Per_All_Assignments_F.business_group_id%TYPE
576: )
577: is
578:
579: cursor pay_txn is

Line 588: l_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;

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

Line 589: l_old_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;

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