APPS.PAY_CA_WF_PKG dependencies on HR_LOOKUPS

Line 579: from hr_lookups

575: between r.effective_start_date and r.effective_end_date;
576:
577: cursor cur_sdr_reporting_dimension is
578: select meaning
579: from hr_lookups
580: where lookup_code = p_sdr_reporting_dimension
581: and lookup_type = 'PAY_CA_REPORT_DIMENSION'
582: and application_id = 800;
583:

Line 664: from hr_lookups

660: where org_payment_method_id = to_number(p_cheque_payment_method);
661:
662: cursor cur_cheque_sort_seq is
663: select meaning
664: from hr_lookups
665: where lookup_code = p_cheque_sort_sequence
666: and lookup_type = 'CHEQUE_PROCEDURE'
667: and enabled_flag = 'Y';
668:

Line 671: from hr_lookups

667: and enabled_flag = 'Y';
668:
669: cursor cur_cheque_style is
670: select meaning
671: from hr_lookups
672: where lookup_code = p_cheque_style
673: and lookup_type = 'CA_CHEQUE_DEPADV'
674: and enabled_flag = 'Y';
675:

Line 678: from hr_lookups

674: and enabled_flag = 'Y';
675:
676: cursor cur_deposit_advice_data_type is
677: select meaning
678: from hr_lookups
679: where lookup_code = p_da_data_type
680: and lookup_type = 'DAR_REPORT'
681: and enabled_flag = 'Y';
682:

Line 706: from hr_lookups

702: between effective_start_date and effective_end_date;
703:
704: cursor cur_costing_summary_accruals is
705: select meaning
706: from hr_lookups
707: where lookup_code = p_cost_summary_accruals
708: and lookup_type = 'PAY_PAYRPCBR';
709:
710: cursor cur_costing_summary_file_out is

Line 745: from hr_lookups

741: where assignment_set_id = to_number(p_cost_detail_asg_set);
742:
743: cursor cur_costing_detail_accruals is
744: select meaning
745: from hr_lookups
746: where lookup_code = p_cost_detail_accruals
747: and lookup_type = 'PAY_PAYRPCBR';
748:
749:

Line 1263: from hr_lookups

1259:
1260: begin
1261: select meaning
1262: into lv_reg_sort_one
1263: from hr_lookups
1264: where lookup_code = p_reg_sort_one
1265: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1266:
1267: hr_utility.trace('lv_reg_sort_one = ' || lv_reg_sort_one );

Line 1277: from hr_lookups

1273:
1274: begin
1275: select meaning
1276: into lv_reg_sort_two
1277: from hr_lookups
1278: where lookup_code = p_reg_sort_two
1279: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1280:
1281: hr_utility.trace('lv_reg_sort_two = ' || lv_reg_sort_two );

Line 1291: from hr_lookups

1287:
1288: begin
1289: select meaning
1290: into lv_reg_sort_three
1291: from hr_lookups
1292: where lookup_code = p_reg_sort_three
1293: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1294:
1295: hr_utility.trace('lv_reg_sort_three = ' || lv_reg_sort_three );