APPS.PAY_GB_ENROLL_INFO_GENE dependencies on PAY_PAYROLLS_F

Line 44: PAY_PAYROLLS_F PPF

40: SELECT PCV.PCV_INFORMATION1,
41: PCV.PCV_INFORMATION2,PCV.PCV_INFORMATION3,
42: PCV.PCV_INFORMATION4
43: FROM PQP_CONFIGURATION_VALUES PCV,
44: PAY_PAYROLLS_F PPF
45: WHERE PCV.PCV_INFORMATION_CATEGORY like 'PAY_GB_ENROLMENT_COMM_DETAILS'
46: AND PPF.business_group_id = PCV.business_group_id
47: AND PPF.PAYROLL_ID = P_PAYROLL_ID ;
48:

Line 55: PAY_PAYROLLS_F PPF

51: IS
52: SELECT PCV.PCV_INFORMATION14,
53: PCV.PCV_INFORMATION15,PCV.PCV_INFORMATION16,PCV.PCV_INFORMATION17
54: FROM PQP_CONFIGURATION_VALUES PCV,
55: PAY_PAYROLLS_F PPF
56: WHERE PCV.PCV_INFORMATION_CATEGORY like 'PAY_GB_QUALIFIED_PENSIONS_INFO'
57: AND PPF.business_group_id = PCV.business_group_id
58: AND PCV.PCV_INFORMATION1 = P_QUALIFYING_SCHEME
59: AND PPF.PAYROLL_ID = P_PAYROLL_ID ;

Line 66: FROM pay_payrolls_f ppf

62:
63: cursor c_tax_ref_details(p_payroll number) IS
64: SELECT trim (org_information3) employer
65: , ppf.period_type period
66: FROM pay_payrolls_f ppf
67: , hr_soft_coding_keyflex hscf
68: , hr_organization_information hoi
69: WHERE ppf.payroll_id = p_payroll
70: AND ppf.business_group_id = hoi.organization_id

Line 264: l_period pay_payrolls_f.period_type%type:= NULL;

260: --------------------------------------
261: l_employer_name VARCHAR2(150):= NULL;
262: l_employee_name per_all_people_f.full_name%type:= NULL;
263: l_email_address per_all_people_f.email_address%type:= NULL;
264: l_period pay_payrolls_f.period_type%type:= NULL;
265: l_earning ff_globals_f.global_value%type:= NULL;
266: l_earning_lower ff_globals_f.global_value%type:= NULL;
267:
268: l_contact_mail_org VARCHAR2(150) := NULL;

Line 1206: l_period pay_payrolls_f.period_type%type:= NULL;

1202:
1203: --------------------------------------
1204: l_employer_name VARCHAR2(150):= NULL;
1205: l_employee_name per_all_people_f.full_name%type:= NULL;
1206: l_period pay_payrolls_f.period_type%type:= NULL;
1207: l_earning ff_globals_f.global_value%type:= NULL;
1208: l_earning_lower ff_globals_f.global_value%type:= NULL;
1209:
1210: l_contact_mail_org VARCHAR2(32767) := NULL;