eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_P35 dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 786: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;

782: l_actid NUMBER;
783: l_locked_action NUMBER;
784: l_out_var VARCHAR2 (30);
785: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
786: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
787: l_temp_person_id per_people_f.person_id%TYPE :=0;
788: l_start_date date;
789: l_end_date date;
790: l_bg_id number;

Line 795: hr_assignment_set_amendments hasa,

791:
792: CURSOR csr_get_flag_from_set
793: IS
794: SELECT DISTINCT hasa.include_or_exclude FROM
795: hr_assignment_set_amendments hasa,
796: hr_assignment_sets has
797: WHERE hasa.assignment_set_id = has.assignment_set_id
798: AND has.business_group_id = l_bg_id
799: AND has.assignment_set_id = l_assignment_set_id;

Line 886: FROM hr_assignment_set_amendments hasa

882: or l_payroll_id is null) -- Vik Added for payroll
883: --and check_assignment_in_set(asg.assignment_id,l_assignment_set_id,l_bg_id)=1
884: AND ((l_assignment_set_id is not null
885: AND (l_set_flag ='I' AND EXISTS(SELECT 1
886: FROM hr_assignment_set_amendments hasa
887: , hr_assignment_sets has
888: , per_assignments_f paf
889: -- , pay_all_payrolls_f pay
890: -- , hr_soft_coding_keyflex hflex

Line 900: FROM hr_assignment_set_amendments hasa

896: --AND paf.payroll_id = pay.payroll_id
897: --AND pay.soft_coding_keyflex_id = hflex.soft_coding_keyflex_id
898: --AND hflex.segment4 = l_segment4)
899: OR l_set_flag = 'E' AND NOT EXISTS(SELECT 1
900: FROM hr_assignment_set_amendments hasa
901: , hr_assignment_sets has
902: , per_assignments_f paf
903: -- , pay_all_payrolls_f pay
904: -- , hr_soft_coding_keyflex hflex

Line 1485: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;

1481: l_pds_id per_periods_of_service.period_of_service_id%TYPE;
1482: l_asg_id per_assignments_f.assignment_id%TYPE;
1483: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1484: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1485: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1486: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;
1487: l_arch_asg_location_id per_assignments_f.location_id%TYPE; -- 10277535
1488: l_arch_org_id per_assignments_f.organization_id%TYPE; -- 11674153
1489: v_primary_flag per_assignments_f.primary_flag%TYPE;

Line 8953: select hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has

8949: ) return NUMBER
8950: AS
8951: CURSOR csr_locked_asg_sets
8952: is
8953: select hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has
8954: where hasa.assignment_set_id = has.assignment_set_id
8955: and has.business_group_id = p_business_group
8956: and has.assignment_set_id = p_assignment_set_id
8957: and hasa.assignment_id = p_assignment_id;

Line 8960: select distinct hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has

8956: and has.assignment_set_id = p_assignment_set_id
8957: and hasa.assignment_id = p_assignment_id;
8958: CURSOR csr_get_flag_from_set
8959: is
8960: select distinct hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has
8961: where hasa.assignment_set_id = has.assignment_set_id
8962: and has.business_group_id = p_business_group
8963: and has.assignment_set_id = p_assignment_set_id;
8964: l_set_flag Varchar2(30) :=null;