APPS.PER_DISPLAY_ACCRUAL_BALANCE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 36

  select pet.element_type_id
    from pay_element_types_f pet,
         pay_element_type_rules per
    where per.element_set_id = p_element_set_id
     AND pet.business_group_id=p_business_group_id
     and per.include_or_exclude = 'I'
     and per.element_type_id = pet.element_type_id
     and p_evaluation_date between
         effective_start_date and effective_end_date;

Line: 48

    SELECT pas.ASSIGNMENT_ID,
           pas.payroll_id,
           pas.business_group_id
    FROM PER_ALL_ASSIGNMENTS_F pas,
         per_assignment_status_types typ
    WHERE pas.PERSON_ID = p_resource_id
       AND pas.ASSIGNMENT_TYPE in ('E','C')
       AND pas.PRIMARY_FLAG = 'Y'
       AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID
       AND typ.PER_SYSTEM_STATUS IN ( 'ACTIVE_ASSIGN','ACTIVE_CWK')
       AND p_evaluation_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE ;

Line: 64

 SELECT  pap.accrual_plan_id,
	 pap_tl.accrual_plan_name,
         pap.information1,  /* 4767298 */
         pap.information_Category  /* 4767298 */
 FROM     pay_accrual_plans pap
         ,pay_element_types_f pet
         ,pay_element_links_f pel
         ,pay_element_entries_f pee
		 ,pay_accrual_plans_tl pap_tl /* 14387376 */
 WHERE
  	 pee.assignment_id = p_assignment_id
 AND
 	 pet.ELEMENT_TYPE_ID=p_element_type_id
 AND
 	 pap.accrual_plan_element_type_id = pet.element_type_id
 AND
 	 pap.accrual_plan_element_type_id  = pel.element_type_id
 AND
 	 pel.element_type_id = pet.element_type_id
 AND
 	 pee.element_type_id = pet.element_type_id
 AND
 	 pel.element_link_id = pee.element_link_id
 AND
	 pap.accrual_plan_id = pap_tl.accrual_plan_id
 AND
	 pap_tl.LANGUAGE(+) = userenv('LANG')
 AND
         p_evaluation_date BETWEEN pee.effective_start_date
                            AND pee.effective_end_date
 AND
 	 pee.effective_start_date BETWEEN pet.effective_start_date
                                   AND pet.effective_end_date
 AND
 	 pee.effective_start_date BETWEEN pel.effective_start_date
                                    AND pel.effective_end_date;

Line: 212

    SELECT pas.ASSIGNMENT_ID
    FROM PER_ALL_ASSIGNMENTS_F pas,
         per_assignment_status_types typ
    WHERE pas.PERSON_ID = p_resource_id
       AND pas.ASSIGNMENT_TYPE in ('E','C')
       AND pas.PRIMARY_FLAG = 'Y'
       AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID
       AND typ.PER_SYSTEM_STATUS IN ( 'ACTIVE_ASSIGN','ACTIVE_CWK')
       AND p_evaluation_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE ;

Line: 263

    SELECT pas.ASSIGNMENT_ID,
           pas.payroll_id,
           pas.business_group_id
    FROM PER_ASSIGNMENTS_F2 pas,
         per_assignment_status_types typ
    WHERE pas.PERSON_ID = p_resource_id
       AND pas.ASSIGNMENT_TYPE in ('E','C')
      -- AND pas.PRIMARY_FLAG = 'Y'
       AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID
       AND typ.PER_SYSTEM_STATUS IN ( 'ACTIVE_ASSIGN','ACTIVE_CWK')
       AND p_evaluation_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE ;

Line: 278

 SELECT  pap_v.accrual_plan_id,
	 pap_tl.accrual_plan_name,
         pap_v.information1,  /* 4767298 */
         pap_v.information_Category  /* 4767298 */
FROM
 	PAY_VIEW_ACCRUAL_PLANS_V pap_v
	,pay_accrual_plans_tl pap_tl /* 14387376 */
WHERE pap_v.ASSIGNMENT_ID = p_assignment_id
AND pap_v.accrual_plan_id = pap_tl.accrual_plan_id
AND pap_tl.LANGUAGE(+) = userenv('LANG')
	    AND p_evaluation_date BETWEEN pap_v.ASG_EFFECTIVE_START_DATE AND pap_v.ASG_EFFECTIVE_END_DATE
    	AND p_evaluation_date BETWEEN pap_v.IV_EFFECTIVE_START_DATE AND pap_v.IV_EFFECTIVE_END_DATE
    	AND p_evaluation_date BETWEEN pap_v.E_ENTRY_EFFECTIVE_START_DATE AND pap_v.E_ENTRY_EFFECTIVE_END_DATE
    	AND p_evaluation_date BETWEEN pap_v.E_TYPE_EFFECTIVE_START_DATE AND pap_v.E_TYPE_EFFECTIVE_END_DATE
    	AND p_evaluation_date BETWEEN pap_v.E_LINK_EFFECTIVE_START_DATE AND pap_v.E_LINK_EFFECTIVE_END_DATE ;