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 197: per_all_assignments_f paf

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

Line 365: per_all_assignments_f paa

361: /* This cursor returns the Disable Proof */
362: Cursor c_disab_details(l_esi_cont_date date) is
363: select pdf.dis_information1
364: from per_disabilities_f pdf,
365: per_all_assignments_f paa
366: where paa.assignment_id = p_assignment_id
367: and paa.person_id = pdf.person_id
368: and l_esi_cont_date between paa.effective_start_date and paa.effective_end_date
369: and l_esi_cont_date between pdf.effective_start_date and pdf.effective_end_date

Line 377: per_all_assignments_f paf

373: CURSOR get_date(l_start date) IS
374: SELECT GREATEST( MIN(ppa.date_earned),l_start)
375: FROM pay_payroll_actions ppa,
376: pay_assignment_actions paa,
377: per_all_assignments_f paf
378: WHERE paf.assignment_id =p_assignment_id
379: AND paf.assignment_id=paa.assignment_id
380: AND paa.payroll_action_id =ppa.payroll_action_id;
381:

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

777: -- 115.0 04-Nov-2004 Vgsriniv 3936280 Initial Version --
778:
779: --------------------------------------------------------------------------
780:
781: FUNCTION sec_80dd_percent ( p_assignment_id IN per_all_assignments_f.assignment_id%type
782: ,p_date_earned IN date)
783: RETURN VARCHAR2 IS
784:
785: CURSOR c_80dd_80_percent is

Line 1001: FROM per_all_assignments_f asg

997: ,p_end_date DATE
998: )
999: IS
1000: SELECT COUNT(DISTINCT scl.segment1)
1001: FROM per_all_assignments_f asg
1002: ,hr_soft_coding_keyflex scl
1003: WHERE asg.assignment_id = p_assignment_id
1004: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1005: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 1023: FROM per_all_assignments_f asg

1019: -- The cursor to find the most recent 'assignment start date' for the effective date
1020: CURSOR c_asg_start_date
1021: IS
1022: SELECT asg.effective_start_date
1023: FROM per_all_assignments_f asg
1024: WHERE p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
1025: AND asg.assignment_id = p_assignment_id;
1026:
1027: -- The cursor to find the presence of an employee in the now selected GRE/Legal

Line 1036: FROM per_all_assignments_f asg

1032:
1033: )
1034: IS
1035: SELECT 1
1036: FROM per_all_assignments_f asg
1037: ,hr_soft_coding_keyflex scl
1038: WHERE asg.assignment_id = p_assignment_id
1039: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1040: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')