APPS.PAY_NL_SI_PKG dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 48: from pqp_assignment_attributes_f paa,

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

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

466: -- Determines the Total Number of days a Work pattern has been
467: -- setup for regardless of the work pattern start date on
468: -- employee assignment or dates of payroll period.
469: FUNCTION Get_Total_Work_Pattern_days(P_Assignment_Id Number) return NUMBER IS
470: cursor c_get_days(p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type,
471: p_business_group_id pqp_assignment_attributes_f.business_group_id%type ) is
472: select count(uci.value)
473: from pay_user_tables put,
474: pay_user_columns puc,

Line 471: p_business_group_id pqp_assignment_attributes_f.business_group_id%type ) is

467: -- setup for regardless of the work pattern start date on
468: -- employee assignment or dates of payroll period.
469: FUNCTION Get_Total_Work_Pattern_days(P_Assignment_Id Number) return NUMBER IS
470: cursor c_get_days(p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type,
471: p_business_group_id pqp_assignment_attributes_f.business_group_id%type ) is
472: select count(uci.value)
473: from pay_user_tables put,
474: pay_user_columns puc,
475: pay_user_column_instances_f uci,

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

496: -- Determines the Total Number of days marked as Working Days in a
497: -- work pattern regardless of the work pattern start date on
498: -- employee assignment or dates of payroll period.
499: FUNCTION Get_Working_Work_Pattern_days(P_Assignment_Id Number) return NUMBER IS
500: cursor c_get_wrk_days (p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type ,
501: p_business_group_id pqp_assignment_attributes_f.business_group_id%type) is
502: select count(uci.value)
503: from pay_user_tables put,
504: pay_user_columns puc,

Line 501: p_business_group_id pqp_assignment_attributes_f.business_group_id%type) is

497: -- work pattern regardless of the work pattern start date on
498: -- employee assignment or dates of payroll period.
499: FUNCTION Get_Working_Work_Pattern_days(P_Assignment_Id Number) return NUMBER IS
500: cursor c_get_wrk_days (p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type ,
501: p_business_group_id pqp_assignment_attributes_f.business_group_id%type) is
502: select count(uci.value)
503: from pay_user_tables put,
504: pay_user_columns puc,
505: pay_user_column_instances_f uci,