APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_PAYROLLS_F

Line 43: L_PERIOD_TYPE PAY_PAYROLLS_F.PERIOD_TYPE%TYPE;

39: L_PAYROLL_ID NUMBER;
40: L_BALANCE_VALUE NUMBER :=0;
41: L_DEFINED_BALANCE_ID NUMBER;
42: L_TOTAL_QUAL_EARNINGS NUMBER;
43: L_PERIOD_TYPE PAY_PAYROLLS_F.PERIOD_TYPE%TYPE;
44: L_PERSON_ID NUMBER;
45: L_AGE NUMBER;
46: L_SEX PER_ALL_PEOPLE_F.SEX%TYPE;
47: L_DATE_OF_BIRTH DATE;

Line 168: FROM pay_payrolls_f

164: --To get the Period_type
165: CURSOR C_PERIOD_TYPE(V_PAYROLL_ID NUMBER)
166: IS
167: SELECT period_type
168: FROM pay_payrolls_f
169: WHERE payroll_id = V_PAYROLL_ID
170: AND L_PRP_END_DATE BETWEEN effective_start_date AND effective_end_date ;
171: --Changed for Pensions 2 - to fetch all the assignment actions for the assignment within the PRP
172: CURSOR C_ASSIGNMENT_ACTION(P_ASSIGNMENT_ID NUMBER)

Line 700: FROM PAY_PAYROLLS_F PPF,

696: SELECT UPPER(SUBSTR(TRIM(HOI.ORG_INFORMATION2),1,35)) PENSION_STAGING_DATE,
697: NVL(UPPER(SUBSTR(LTRIM(HOI.ORG_INFORMATION3),1,35)),'NONE') WORKER_POSTPONEMENT_RULE,
698: NVL(UPPER(SUBSTR(LTRIM(HOI.ORG_INFORMATION4),1,35)),'NONE') ELIGIBLE_POSPONEMENT_RULE,
699: PPF.PERIOD_TYPE
700: FROM PAY_PAYROLLS_F PPF,
701: HR_SOFT_CODING_KEYFLEX HSCF,
702: HR_ORGANIZATION_INFORMATION HOI
703: WHERE PPF.PAYROLL_ID = P_PAYROLL_ID
704: AND PPF.BUSINESS_GROUP_ID = HOI.ORGANIZATION_ID

Line 733: FROM PAY_PAYROLLS_F

729: --To Fetch Payroll Name
730: CURSOR C_PAYROLL_NAME
731: IS
732: SELECT PAYROLL_NAME
733: FROM PAY_PAYROLLS_F
734: WHERE PAYROLL_ID = G_PAYROLL_ID
735: AND G_PRP_END_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
736: --This cursor will check whether the default Pension element entered is a QUALIFYING pension scheme or not.
737: CURSOR C_VALIDATE_PENSION_INFO(P_SCHEME_ELEMENT_NAME VARCHAR2 )

Line 1822: pay_payrolls_f b

1818: CURSOR c_payroll(p_payroll_name VARCHAR2)
1819: IS
1820: SELECT 1
1821: FROM per_all_assignments_f a,
1822: pay_payrolls_f b
1823: WHERE assignment_id =p_assignment_id
1824: AND b.business_group_id = G_BUSINESS_GROUP_ID
1825: AND b.PAYROLL_ID = a.PAYROLL_ID
1826: AND b.payroll_name =p_payroll_name

Line 4189: FROM PAY_PAYROLLS_F PPF,

4185: -- to get pensions staging date at Payee/Employer level
4186: CURSOR C_PAYEE_PENSION_STAGING_DATE
4187: IS
4188: SELECT UPPER(SUBSTR(TRIM(HOI.ORG_INFORMATION2),1,35)) PENSION_STAGING_DATE
4189: FROM PAY_PAYROLLS_F PPF,
4190: HR_SOFT_CODING_KEYFLEX HSCF,
4191: HR_ORGANIZATION_INFORMATION HOI
4192: WHERE PPF.PAYROLL_ID = G_PAYROLL_ID
4193: AND PPF.BUSINESS_GROUP_ID = HOI.ORGANIZATION_ID