APPS.PAY_NO_K27_REIM_UPLD dependencies on PAY_PAYROLLS_F

Line 103: pay_payrolls_f ppf,

99: IS
100: select distinct ptp.start_date
101: from
102: per_all_assignments_f paaf,
103: pay_payrolls_f ppf,
104: per_time_periods ptp
105: where
106: paaf.assignment_id = p_assignment_id
107: AND paaf.business_group_id = p_business_group_id

Line 1045: select payroll_name from pay_payrolls_f

1041:
1042: /* Payroll Name */
1043: CURSOR csr_payroll_name(id pay_all_payrolls_f.payroll_id%type)
1044: IS
1045: select payroll_name from pay_payrolls_f
1046: where payroll_id=id;
1047:
1048: -- rg_csr_payroll_name csr_payroll_name%rowtype;
1049: l_payroll_name VARCHAR2(100):=NULL;

Line 1066: pay_payrolls_f ppf,

1062: ,'Week' ,'3'
1063: ,'Lunar Month' ,'4') PAYROLL_PERIOD,
1064: ptp.TIME_PERIOD_ID
1065: FROM
1066: pay_payrolls_f ppf,
1067: per_assignments_f paf,
1068: hr_organization_units hou,
1069: hr_organization_information hoi,
1070: hr_soft_coding_keyflex scl,

Line 1106: FROM pay_payrolls_f ppf

1102: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
1103:
1104: CURSOR get_value_from_ddf(p_payroll_id NUMBER , p_date_earned DATE) IS
1105: SELECT PRL_INFORMATION1, Payroll_name
1106: FROM pay_payrolls_f ppf
1107: WHERE PAYROLL_ID = p_payroll_id
1108: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
1109:
1110: BEGIN