APPS.PAY_DK_ARCHIVE_EIN dependencies on PAY_PAYROLLS_F

Line 274: select payroll_name from pay_payrolls_f

270:
271: /* Payroll Name */
272: CURSOR csr_payroll_name(id pay_all_payrolls_f.payroll_id%type)
273: IS
274: select payroll_name from pay_payrolls_f
275: where payroll_id=id;
276:
277: -- rg_csr_payroll_name csr_payroll_name%rowtype;
278: l_payroll_name VARCHAR2(100):=NULL;

Line 295: pay_payrolls_f ppf,

291: ,'Week' ,'3'
292: ,'Lunar Month' ,'4') PAYROLL_PERIOD,
293: ptp.TIME_PERIOD_ID
294: FROM
295: pay_payrolls_f ppf,
296: per_assignments_f paf,
297: hr_organization_units hou,
298: hr_organization_information hoi,
299: hr_soft_coding_keyflex scl,

Line 995: pay_payrolls_f ppf,

991: ppf.payroll_name,
992: ptp.period_name
993:
994: FROM
995: pay_payrolls_f ppf,
996: per_assignments_f paf,
997: per_time_periods ptp
998: WHERE paf.payroll_id = ppf.payroll_id
999: AND paf.assignment_id=c_assignment_id

Line 1182: FROM pay_payrolls_f ppf

1178: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
1179:
1180: CURSOR get_value_from_ddf(p_payroll_id NUMBER , p_date_earned DATE) IS
1181: SELECT PRL_INFORMATION1
1182: FROM pay_payrolls_f ppf
1183: WHERE PAYROLL_ID = p_payroll_id
1184: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
1185:
1186: CURSOR cur_max_asg_act_id(p_assignment_id NUMBER, p_start_date DATE, p_end_date DATE) IS