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_FR_DADS_EMP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 77: , pay_assignment_actions paa

73: , paf.assignment_id assignment_id -- assignment_id , p_id
74: , ppf.employee_number employee_number -- this will be the id2 column
75: From per_all_people_f ppf
76: , per_all_assignments_f paf
77: , pay_assignment_actions paa
78: , per_addresses pa
79: , fnd_territories ft
80: , fnd_territories_tl ft_tl
81: , fnd_territories ft1

Line 690: ,pay_assignment_actions paa

686: ,least(asg.effective_end_date, g_effective_date) end_date
687: ,paa.assignment_action_id
688: ,org_est.org_information1
689: from per_all_assignments_f asg
690: ,pay_assignment_actions paa
691: ,hr_soft_coding_keyflex scl
692: ,hr_organization_information org_est
693: where paa.assignment_action_id = g_assign_action_id
694: and asg.effective_end_date >= g_param_start_date

Line 715: ,pay_assignment_actions paa

711: ,least(asg.effective_end_date, c_end_date) end_date
712: ,paa.assignment_action_id
713: ,org_est.org_information1
714: from per_all_assignments_f asg
715: ,pay_assignment_actions paa
716: ,hr_soft_coding_keyflex scl
717: ,hr_organization_information org_est
718: where paa.assignment_action_id = g_assign_action_id
719: and asg.effective_start_date >= c_param_start_date

Line 744: ,pay_assignment_actions paa

740: ,least(pee.effective_end_Date, g_effective_date) end_date
741: from pay_element_entries_f pee
742: ,per_all_assignments_f asg
743: ,hr_organization_information org_est
744: ,pay_assignment_actions paa
745: where paa.assignment_action_id = g_assign_action_id
746: and pee.assignment_id = asg.assignment_id
747: and asg.assignment_id = paa.assignment_id
748: and asg.establishment_id = org_est.organization_id

Line 769: ,pay_assignment_actions paa

765: ,nvl(paa_date.start_date, (ppa.date_earned - to_number(to_char(ppa.date_earned, 'DD')) + 1)) calc_start_date
766: ,nvl(paa_date.end_date, ppa.date_earned) end_date
767: from pay_action_contexts pac
768: ,ff_contexts fc
769: ,pay_assignment_actions paa
770: ,pay_assignment_actions paa_date
771: ,pay_payroll_actions ppa
772: where pac.assignment_id = paa.assignment_id
773: and pac.assignment_action_id = paa.assignment_action_id

Line 770: ,pay_assignment_actions paa_date

766: ,nvl(paa_date.end_date, ppa.date_earned) end_date
767: from pay_action_contexts pac
768: ,ff_contexts fc
769: ,pay_assignment_actions paa
770: ,pay_assignment_actions paa_date
771: ,pay_payroll_actions ppa
772: where pac.assignment_id = paa.assignment_id
773: and pac.assignment_action_id = paa.assignment_action_id
774: and fc.context_id = pac.context_id

Line 790: from pay_assignment_actions paa

786: , pcf.status status
787: , pcf.contract_id contract_id
788: , asg.effective_start_date start_date
789: , least(pcf.effective_end_date, c_end_date) end_date
790: from pay_assignment_actions paa
791: ,per_all_assignments_f asg
792: ,per_contracts_f pcf
793: ,hr_organization_information org_est
794: where paa.assignment_action_id = g_assign_action_id

Line 816: From pay_assignment_actions paa

812: || ' 00:00:00', 'dd-mm-yyyy hh24:mi:ss')
813: ,c_param_start_date) start_date
814: ,asg.effective_start_date asg_start_date
815: ,least(asg.effective_end_date,c_end_date) asg_end_date
816: From pay_assignment_actions paa
817: ,per_all_assignments_f asg
818: ,hr_organization_information org_est
819: where paa.assignment_action_id = g_assign_action_id
820: and asg.effective_start_date <= c_end_date

Line 838: from pay_assignment_actions paa

834: -- Mutation in another establishment in the company Get the prior establishmentid
835: Cursor csr_19(p_person_id number) IS
836: (select asg.establishment_id, org_est.org_information1 company_id
837: ,asg.effective_start_date start_date, 'FIRST' type
838: from pay_assignment_actions paa
839: ,per_all_assignments_f asg
840: ,hr_organization_information org_est
841: where paa.assignment_action_id = g_assign_action_id
842: and asg.assignment_id = paa.assignment_id

Line 852: from pay_assignment_actions paa

848: union all
849: -- Get all the changes in company id
850: (select asg.establishment_id, org_est.org_information1 company_id
851: ,asg.effective_start_date start_date, 'HIST' type
852: from pay_assignment_actions paa
853: ,per_all_assignments_f asg
854: ,hr_organization_information org_est
855: where paa.assignment_action_id = g_assign_action_id
856: and asg.assignment_id = paa.assignment_id

Line 871: From pay_assignment_actions paa

867: --NIC of the assignment Establishment...
868: Cursor csr_NIC(p_person_id Number, p_org_id Varchar2) IS
869: Select asg.effective_start_date start_date, asg.establishment_id
870: , substr(org_est.org_information2,length(org_est.org_information2)-4, 5)
871: From pay_assignment_actions paa
872: ,per_all_assignments_f asg
873: ,hr_organization_information org_est
874: Where paa.assignment_action_id = g_assign_action_id
875: and asg.assignment_id = paa.assignment_id

Line 902: ,pay_assignment_actions paa

898: ,hou_issue_estab_tl.name issue_estab_name
899: ,hloc_asg_estab_tl.location_code location_name
900: ,asg_estab_tl.name asg_estab_name
901: From per_all_assignments_f asg
902: ,pay_assignment_actions paa
903: ,hr_organization_information org_est
904: ,hr_all_organization_units hou
905: ,hr_locations_all hla
906: ,hr_locations_all_tl hloc_asg_estab_tl

Line 945: From pay_assignment_actions paa

941: ,hla.location_id est_location
942: ,hou_issue_estab_tl.name issue_estab_name
943: ,hloc_asg_estab_tl.location_code location_name
944: ,asg_estab_tl.name asg_estab_name
945: From pay_assignment_actions paa
946: ,per_all_assignments_f asg
947: ,hr_organization_information org_est
948: ,hr_locations_all hla
949: ,hr_locations_all_tl hloc_asg_estab_tl

Line 1000: ,pay_assignment_actions paa

996: , pca.CAG_INFORMATION1 col_aggr_code --S41.G01.00.016
997: , asg.assignment_id assignment_id -- used for fetch conventional classfication --S41.G01.00.017
998: /* DECODE(SEX, 'F', DECODE(NVL(PER_INFORMATION1, PREVIOUS_LAST_NAME), LAST_NAME, NULL,LAST_NAME) , 'M', DECODE( PREVIOUS_LAST_NAME, LAST_NAME, NULL, LAST_NAME)) Name --Getting the employee full name*/
999: From per_all_assignments_f asg
1000: ,pay_assignment_actions paa
1001: , per_jobs pj
1002: , per_all_people_f paf
1003: , per_contracts_f pc
1004: , HR_SOFT_CODING_KEYFLEX sck

Line 1034: ,pay_assignment_actions paa

1030: , pay_element_links_f pel
1031: , pay_element_types_f pet
1032: , per_all_assignments_f asg
1033: , hr_organization_information org_est
1034: ,pay_assignment_actions paa
1035: Where paa.assignment_action_id = g_assign_action_id
1036: and pef.assignment_id = asg.assignment_id
1037: and paa.assignment_id = asg.assignment_id
1038: And asg.person_id = p_person_id

Line 1079: ,pay_assignment_actions paa

1075: ,pps.Leaving_reason leav_reason
1076: From per_periods_of_service pps
1077: ,per_all_assignments_f asg
1078: ,hr_organization_information org_est
1079: ,pay_assignment_actions paa
1080: Where paa.assignment_action_id = g_assign_action_id
1081: and org_est.org_information1 = p_org_id
1082: And pps.person_id = asg.person_id
1083: And asg.person_id = p_person_id

Line 1159: , pay_assignment_actions paa

1155: Cursor csr_get_per_dates(p_effective_date DATE) Is
1156: select ptp.end_date
1157: ,ptp.start_date
1158: from pay_action_interlocks pai
1159: , pay_assignment_actions paa
1160: , pay_payroll_actions ppa
1161: , per_time_periods ptp
1162: where pai.locking_action_id = g_assign_action_id
1163: and paa.assignment_action_id = pai.locked_action_id

Line 1241: l_payroll_action_id pay_assignment_actions.payroll_action_id%type;

1237:
1238: l_param_start_date DATE;
1239: l_effective_date DATE;
1240:
1241: l_payroll_action_id pay_assignment_actions.payroll_action_id%type;
1242: l_counter NUMBER;
1243: l_flag BOOLEAN;
1244: l_097_exists NUMBER;
1245: l_date_start DATE;

Line 1609: from pay_assignment_actions paa

1605: l_first_row := TRUE;
1606: BEGIN
1607: select max(ppa.date_earned)
1608: into c_start_date
1609: from pay_assignment_actions paa
1610: ,pay_payroll_actions ppa
1611: where paa.assignment_id = p_assignment_id
1612: and ppa.payroll_action_id = paa.payroll_action_id
1613: and ppa.date_earned < g_param_start_date

Line 3928: from pay_assignment_actions paa,

3924: select ppa.payroll_action_id,
3925: nvl(paa_pro.end_date, ppa.date_earned) date_earned,
3926: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3927: paa.assignment_action_id),16)) assignment_action_id
3928: from pay_assignment_actions paa,
3929: pay_assignment_actions paa_pro,
3930: pay_payroll_actions ppa
3931: where paa.assignment_id = p_assignment_id
3932: and paa_pro.assignment_action_id (+) = paa.source_action_id

Line 3929: pay_assignment_actions paa_pro,

3925: nvl(paa_pro.end_date, ppa.date_earned) date_earned,
3926: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3927: paa.assignment_action_id),16)) assignment_action_id
3928: from pay_assignment_actions paa,
3929: pay_assignment_actions paa_pro,
3930: pay_payroll_actions ppa
3931: where paa.assignment_id = p_assignment_id
3932: and paa_pro.assignment_action_id (+) = paa.source_action_id
3933: and paa_pro.end_date(+) is not null

Line 3942: , pay_assignment_actions RASSACT

3938: and ppa.action_type In ('R', 'Q', 'I')
3939: and NOT EXISTS
3940: (SELECT NULL
3941: FROM pay_payroll_actions RPACT
3942: , pay_assignment_actions RASSACT
3943: , pay_action_interlocks RINTLK
3944: where paa.assignment_action_id = RINTLK.locked_action_id
3945: and RINTLK.locking_action_id = RASSACT.assignment_action_id
3946: and RPACT.payroll_action_id = RASSACT.payroll_action_id