APPS.PAY_IN_FF_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 34: FROM per_all_assignments_f paa,

30: ,p_payroll_action_id IN NUMBER)
31: RETURN NUMBER IS
32: CURSOR c_emp_cat IS
33: SELECT nvl(paa.employee_category,'X')
34: FROM per_all_assignments_f paa,
35: pay_payroll_actions ppa
36: WHERE paa.assignment_id = p_assignment_id
37: AND ppa.payroll_action_id = p_payroll_action_id
38: AND paa.payroll_id = ppa.payroll_id

Line 105: per_all_assignments_f paa

101: CURSOR c_get_edli IS
102: SELECT hoi.org_information7
103: FROM hr_organization_information hoi,
104: hr_soft_coding_keyflex hsk,
105: per_all_assignments_f paa
106: WHERE hoi.org_information_context = 'PER_IN_PF_DF'
107: AND hoi.organization_id = hsk.segment2
108: AND hsk.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
109: AND paa.assignment_id = p_assignment_id

Line 195: per_all_assignments_f paf

191: CURSOR get_date(l_start date) IS
192: SELECT GREATEST( MIN(ppa.date_earned),l_start)
193: FROM pay_payroll_actions ppa,
194: pay_assignment_actions paa,
195: per_all_assignments_f paf
196: WHERE paf.assignment_id =p_assignment_id
197: AND paf.assignment_id=paa.assignment_id
198: AND paa.payroll_action_id =ppa.payroll_action_id;
199:

Line 359: per_all_assignments_f paa

355: /* This cursor returns the Disable Proof */
356: Cursor c_disab_details(l_esi_cont_date date) is
357: select pdf.dis_information1
358: from per_disabilities_f pdf,
359: per_all_assignments_f paa
360: where paa.assignment_id = p_assignment_id
361: and paa.person_id = pdf.person_id
362: and l_esi_cont_date between paa.effective_start_date and paa.effective_end_date
363: and l_esi_cont_date between pdf.effective_start_date and pdf.effective_end_date

Line 371: per_all_assignments_f paf

367: CURSOR get_date(l_start date) IS
368: SELECT GREATEST( MIN(ppa.date_earned),l_start)
369: FROM pay_payroll_actions ppa,
370: pay_assignment_actions paa,
371: per_all_assignments_f paf
372: WHERE paf.assignment_id =p_assignment_id
373: AND paf.assignment_id=paa.assignment_id
374: AND paa.payroll_action_id =ppa.payroll_action_id;
375:

Line 775: FUNCTION sec_80dd_percent ( p_assignment_id IN per_all_assignments_f.assignment_id%type

771: -- 115.0 04-Nov-2004 Vgsriniv 3936280 Initial Version --
772:
773: --------------------------------------------------------------------------
774:
775: FUNCTION sec_80dd_percent ( p_assignment_id IN per_all_assignments_f.assignment_id%type
776: ,p_date_earned IN date)
777: RETURN VARCHAR2 IS
778:
779: CURSOR c_80dd_80_percent is

Line 995: FROM per_all_assignments_f asg

991: ,p_end_date DATE
992: )
993: IS
994: SELECT COUNT(DISTINCT scl.segment1)
995: FROM per_all_assignments_f asg
996: ,hr_soft_coding_keyflex scl
997: WHERE asg.assignment_id = p_assignment_id
998: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
999: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 1017: FROM per_all_assignments_f asg

1013: -- The cursor to find the most recent 'assignment start date' for the effective date
1014: CURSOR c_asg_start_date
1015: IS
1016: SELECT asg.effective_start_date
1017: FROM per_all_assignments_f asg
1018: WHERE p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
1019: AND asg.assignment_id = p_assignment_id;
1020:
1021: -- The cursor to find the presence of an employee in the now selected GRE/Legal

Line 1030: FROM per_all_assignments_f asg

1026:
1027: )
1028: IS
1029: SELECT 1
1030: FROM per_all_assignments_f asg
1031: ,hr_soft_coding_keyflex scl
1032: WHERE asg.assignment_id = p_assignment_id
1033: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1034: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')