APPS.PAY_NL_SI_PKG dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 50: from pqp_assignment_attributes_f paa,

46: g_tax_proration_flag VARCHAR2(1);
47:
48: cursor c_wp_dets(p_assignment_id NUMBER ) is
49: select *
50: from pqp_assignment_attributes_f paa,
51: fnd_sessions ses
52: where assignment_id = p_assignment_id
53: and ses.session_id = userenv('sessionid')
54: and ses.effective_date between paa.effective_start_date and paa.effective_end_date;

Line 487: cursor c_get_days(p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type,

483: -- Determines the Total Number of days a Work pattern has been
484: -- setup for regardless of the work pattern start date on
485: -- employee assignment or dates of payroll period.
486: FUNCTION Get_Total_Work_Pattern_days(P_Assignment_Id Number) return NUMBER IS
487: cursor c_get_days(p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type,
488: p_business_group_id pqp_assignment_attributes_f.business_group_id%type ) is
489: select count(uci.value)
490: from pay_user_tables put,
491: pay_user_columns puc,

Line 488: p_business_group_id pqp_assignment_attributes_f.business_group_id%type ) is

484: -- setup for regardless of the work pattern start date on
485: -- employee assignment or dates of payroll period.
486: FUNCTION Get_Total_Work_Pattern_days(P_Assignment_Id Number) return NUMBER IS
487: cursor c_get_days(p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type,
488: p_business_group_id pqp_assignment_attributes_f.business_group_id%type ) is
489: select count(uci.value)
490: from pay_user_tables put,
491: pay_user_columns puc,
492: pay_user_column_instances_f uci,

Line 517: cursor c_get_wrk_days (p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type ,

513: -- Determines the Total Number of days marked as Working Days in a
514: -- work pattern regardless of the work pattern start date on
515: -- employee assignment or dates of payroll period.
516: FUNCTION Get_Working_Work_Pattern_days(P_Assignment_Id Number) return NUMBER IS
517: cursor c_get_wrk_days (p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type ,
518: p_business_group_id pqp_assignment_attributes_f.business_group_id%type) is
519: select count(uci.value)
520: from pay_user_tables put,
521: pay_user_columns puc,

Line 518: p_business_group_id pqp_assignment_attributes_f.business_group_id%type) is

514: -- work pattern regardless of the work pattern start date on
515: -- employee assignment or dates of payroll period.
516: FUNCTION Get_Working_Work_Pattern_days(P_Assignment_Id Number) return NUMBER IS
517: cursor c_get_wrk_days (p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type ,
518: p_business_group_id pqp_assignment_attributes_f.business_group_id%type) is
519: select count(uci.value)
520: from pay_user_tables put,
521: pay_user_columns puc,
522: pay_user_column_instances_f uci,