APPS.PAY_PPMV4_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 845: , per_all_assignments_f paa

841: ,p_org_payment_id in number
842: ) is
843: select opm.org_payment_method_id opmid
844: from pay_org_payment_methods_f opm
845: , per_all_assignments_f paa
846: , pay_org_pay_method_usages_f popmu
847: , pay_payment_types ppt
848: where paa.assignment_id = p_assignment_id
849: and p_effective_date between

Line 870: , per_all_assignments_f paa

866: ,p_category in varchar2
867: ) is
868: select opm.org_payment_method_id opmid
869: from pay_org_payment_methods_f opm
870: , per_all_assignments_f paa
871: , pay_org_pay_method_usages_f popmu
872: , pay_payment_types ppt
873: where paa.assignment_id = p_assignment_id
874: and p_effective_date between

Line 1087: , per_all_assignments_f paa

1083: ) is
1084: select opm.org_payment_method_name name
1085: , opm.org_payment_method_id opmid
1086: from pay_org_payment_methods_f opm
1087: , per_all_assignments_f paa
1088: , pay_org_pay_method_usages_f popmu
1089: , pay_payment_types ppt
1090: where paa.assignment_id = p_assignment_id
1091: and p_effective_date between

Line 1278: from per_all_assignments_f paa

1274: select ppt.category
1275: , nvl(ppt.territory_code, hr_api.return_legislation_code(paa.business_group_id))
1276: , pap.prl_information3
1277: , paa.payroll_id
1278: from per_all_assignments_f paa
1279: , pay_all_payrolls_f pap
1280: , pay_org_payment_methods_f popm
1281: , pay_payment_types ppt
1282: where paa.assignment_id = p_assignment_id

Line 1298: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

1294: l_payment_type varchar2(2000);
1295: l_territory_code varchar2(2000);
1296: l_prenote_allowed varchar2(2000);
1297: l_proc varchar2(2000) := g_package || 'getpayrollinfo';
1298: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1299:
1300: begin
1301: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'ENTER', 0);
1302: open csr_getpayrollinfo

Line 1621: from per_all_assignments_f a

1617: l_stage := 'ASSIGNMENT_ID:1';
1618: l_assignment_id := to_number(p_assignment_id);
1619: select person_id
1620: into l_person_id
1621: from per_all_assignments_f a
1622: where a.assignment_id = l_assignment_id
1623: and l_effective_date
1624: between a.effective_start_date and a.effective_end_date;
1625: --

Line 1667: , per_all_assignments_f asg

1663: , pbg.business_group_id
1664: into l_territory_code
1665: , l_business_group_id
1666: from per_business_groups pbg
1667: , per_all_assignments_f asg
1668: where asg.assignment_id = l_assignment_id
1669: and l_effective_date between
1670: asg.effective_start_date and asg.effective_end_date
1671: and pbg.business_group_id + 0 = asg.business_group_id;