APPS.PAY_PPMV4_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 776: , per_all_assignments_f paa

772: ,p_org_payment_id in number
773: ) is
774: select opm.org_payment_method_id opmid
775: from pay_org_payment_methods_f opm
776: , per_all_assignments_f paa
777: , pay_org_pay_method_usages_f popmu
778: , pay_payment_types ppt
779: where paa.assignment_id = p_assignment_id
780: and p_effective_date between

Line 801: , per_all_assignments_f paa

797: ,p_category in varchar2
798: ) is
799: select opm.org_payment_method_id opmid
800: from pay_org_payment_methods_f opm
801: , per_all_assignments_f paa
802: , pay_org_pay_method_usages_f popmu
803: , pay_payment_types ppt
804: where paa.assignment_id = p_assignment_id
805: and p_effective_date between

Line 1012: , per_all_assignments_f paa

1008: ) is
1009: select opm.org_payment_method_name name
1010: , opm.org_payment_method_id opmid
1011: from pay_org_payment_methods_f opm
1012: , per_all_assignments_f paa
1013: , pay_org_pay_method_usages_f popmu
1014: , pay_payment_types ppt
1015: where paa.assignment_id = p_assignment_id
1016: and p_effective_date between

Line 1203: from per_all_assignments_f paa

1199: select ppt.category
1200: , nvl(ppt.territory_code, hr_api.return_legislation_code(paa.business_group_id))
1201: , pap.prl_information3
1202: , paa.payroll_id
1203: from per_all_assignments_f paa
1204: , pay_all_payrolls_f pap
1205: , pay_org_payment_methods_f popm
1206: , pay_payment_types ppt
1207: where paa.assignment_id = p_assignment_id

Line 1223: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

1219: l_payment_type varchar2(2000);
1220: l_territory_code varchar2(2000);
1221: l_prenote_allowed varchar2(2000);
1222: l_proc varchar2(2000) := g_package || 'getpayrollinfo';
1223: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1224:
1225: begin
1226: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'ENTER', 0);
1227: open csr_getpayrollinfo

Line 1546: from per_all_assignments_f a

1542: l_stage := 'ASSIGNMENT_ID:1';
1543: l_assignment_id := to_number(p_assignment_id);
1544: select person_id
1545: into l_person_id
1546: from per_all_assignments_f a
1547: where a.assignment_id = l_assignment_id
1548: and l_effective_date
1549: between a.effective_start_date and a.effective_end_date;
1550: --

Line 1592: , per_all_assignments_f asg

1588: , pbg.business_group_id
1589: into l_territory_code
1590: , l_business_group_id
1591: from per_business_groups pbg
1592: , per_all_assignments_f asg
1593: where asg.assignment_id = l_assignment_id
1594: and l_effective_date between
1595: asg.effective_start_date and asg.effective_end_date
1596: and pbg.business_group_id + 0 = asg.business_group_id;